Unrecognized database format accdb in visual studio

jeremiah picture jeremiah · Nov 10, 2017 · Viewed 11.5k times · Source
  • I am using visual studio community 2017
  • Access 2010 - 2016
  • I can import an access file I created
  • File sent from client contains(tables, queries, forms, macros, and modules)
  • Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\jeremiah\Documents\Batching.accdb
  • The client sent me another basic file, was able to open without a problem

So I been through all current StackOverFlow solutions for people reporting the unrecognized database error and none of them have been useful.

My only theory is that the database they are using is to complicated to be used as a data source for visual studio.Do you have any suggestions?

Answer

Mubarek picture Mubarek · Nov 10, 2017

I may not tell you what the problem is but I solved this issue before by resaving the database file as Microsoft Access 2003. Goto Save Database As Access 2002-2003 (*.mdb) and then use the new file.