I have a problem after migrating my mdb database to accdb using MS access

Question

0.00/5 (No votes)

See more:

When trying to use my VB.Net application to connect to accdb file that was originally converted from mdb using MS Access it the application gave me Unrecognized database format however when reversing the action and use the original mdb file it works normally also the migrated accdb file is accessible normally using MS Access

What I have tried:

Private Sub FillCustDataGrid()
    Try
        Dim sqlQRY As String
        sqlQRY = "Select * From Customers WHERE DateAdded >= #" + Today + "#"
        Dim da As OleDbDataAdapter
        Dim ds As DataSet = New DataSet
        da = New OleDbDataAdapter(sqlQRY, cnnOLEDB)
        Dim cb As OleDbCommandBuilder = New OleDbCommandBuilder(da)
        da.Fill(ds, "Customers")
        DataGridViewCustomer.DataSource = ds
        DataGridViewCustomer.DataMember = "Customers"
        lbl_RowCount.Text = DataGridViewCustomer.RowCount
        Dim row As Integer
        If DataGridViewCustomer.RowCount > 0 Then
            row = DataGridViewCustomer.FirstDisplayedCell.RowIndex
            DataGridViewCustomer.Rows(row).Selected = True
            DataGridViewCustomer.Sort(DataGridViewCustomer.Columns(6), ListSortDirection.Ascending)
            If RowIndex_Cust_TXT.Text = vbNullString Then
                Exit Sub
            Else
                Me.DataGridViewCustomer.ClearSelection()
                Me.DataGridViewCustomer.Rows(RowIndex_Cust_TXT.Text).Selected = True
                Me.DataGridViewCustomer.FirstDisplayedScrollingRowIndex = RowIndex_Cust_TXT.Text
            End If
        Else
            row = 0
        End If
    Catch ex As OleDbException
        MessageBox.Show(ex.Message)
    End Try
End Sub

Posted 16-Sep-19 22:53pm

BassamKassem

Updated 16-Sep-19 23:20pm

Add a Solution

Comments

Richard Deeming 17-Sep-19 13:30pm

sqlQRY = "Select * From Customers WHERE DateAdded >= #" + Today + "#"

Don't do it like that!

In this specific case, since the parameter is a date, you might get away with it. But using string concatenation to build database queries can and will lead to SQL Injection[^] vulnerabilities.

Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^]
How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^]
Query Parameterization Cheat Sheet | OWASP[^]

Const sqlQRY As String = "Select * From Customers WHERE DateAdded >= ?"
Dim da As New OleDbDataAdapter(sqlQRY, cnnOLEDB)
da.SelectCommand.Parameters.AddWithValue("@p0", Today)

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2019-09-16T23:07:00

Solution 1

You most likely need to upgrade to the latest Access DB engine: Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center[^].

Posted 16-Sep-19 23:07pm

Richard MacCutchan

Comments

Maciej Los 17-Sep-19 5:12am

5ed!

Maciej Los · Accepted Answer · 2019-09-16T23:14:00

Solution 2

In addition to solution #1 by Richard MacCutchan[^] you'll need to change connection string. See: Access connection strings - ConnectionStrings.com[^]

Posted 16-Sep-19 23:14pm

Maciej Los

Comments

BassamKassem 17-Sep-19 10:50am

your solution is working with some users that have Microsoft office 32bit as for those whom having 64 it gave them error "the microsoft.ace.oledb.12.0 provider is not registered on local machine"

and the problem is that this application is added to shared folder with multiple users some have MS office 32 and others have 64bit version . so any help with that to make it universal with all kind of versions

Maciej Los 17-Sep-19 11:02am

Please, read this:
OLEDB Provider is Not Registered on the Local Machine[^]
https://www.aspsnippets.com/Articles/The-MicrosoftACEOLEDB120-provider-is-not-registered-on-the-local-machine.aspx[^]