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.

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 to George Cancel reply