Share via

Unrecognized database format accdbb

Anonymous
2017-03-23T11:00:07+00:00

I'm trying to connect c# windows form to Access database and when trying to add a new data source I see an error message saying: "Unrecognized database format..."

When I open Advanced options in Data Source Configuration Wizard I see tis connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Users\MyPC\Documents\Access Databases\sample_database.accdb"

I'm using Office 365 (MS Access is a part of this subscription), Visual Studio Community 2015, .Net Framework 4.5 or 4.6.

Is the problem with Microsoft.ACE.OLEDB version here and which one should be used? I'm not sure if this version is obsolete in my case: https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255

Or something else is an issue.

Many thanks!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2017-03-23T12:35:06+00:00

What version of Access database are you accessing? If it's 2007 or later, you cannot use the Jet 4.0 to do that. You'd have to use the microsoft.ace.oledb.12.0 driver.

You'll also need to set your project for x86 compatibility.

Was this answer helpful?

8 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-03-23T14:01:27+00:00

    Thank you Scott. I installed microsoft.ace.oledb.12.0 driver and it solved the problem.

    Best,

    Was this answer helpful?

    0 comments