Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unrecognized database format accdb in visual studio

  • 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?

like image 722
jeremiah Avatar asked Nov 10 '17 18:11

jeremiah


People also ask

How do I fix Microsoft Access Unrecognized database format error?

mdb file becomes corrupt, and everybody else using Access on their local PCs get the "Unrecognized database format" error message (see picture). So I have to restart the server, erase the . ldb temporary file and then click on "Compact and restore database" option under Database Tools tab. That fixes the problem.

How do I open an unrecognized database in Access?

The problem with an unrecognized database can be solved after converting it to an earlier database format. It is also not difficult to do: Go to the database and click on the Tools tab. Next, select Convert Database from the list, and then select the tab to access the file format version.


1 Answers

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.

like image 134
Mubarek Avatar answered Sep 28 '22 21:09

Mubarek