Skip to content

Unrecognized database format ‘mydata.accdb’.

20 April 2011

I had to upgrade an old Windows Form application using Access database. On the row where connection was executing its Open() method I faced following error:

Unrecognized database format 'mydata.accdb'.

It turns out that it is an easy fix – just replace provider attribute’s value of the connection string like this

old value

Provider=Microsoft.Jet.OLEDB.4.0

new value

Provider=Microsoft.ACE.OLEDB.12.0

Hope to be useful.

Advertisements

From → C#, Tips

8 Comments
  1. Preash permalink

    thank you very much. works perfectly.

  2. Aayush permalink

    Thank you very very much… my simple beginner program now works fine….

  3. punithasabareeswar permalink

    Thank you…………….

  4. punithasabareeswar permalink

    simple and clear

  5. Sunil permalink

    i faced this error…
    The ‘Microsoft.Jet.OLEDB.12.0’ provider is not registered on the local machine.

  6. Rasha permalink

    Thanks….

  7. George permalink

    Thanks, just what I needed!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: