Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unrecognized database format'C:\.....\Employees.accdb for Microsoft Access Database File?

I am trying to access a file stored in a Microsoft Access database. (I am working in Visual Studio 2012) I chose the Database source type, and the Dataset database model, when it asks me "which data connection should your application use to connect to the database?", I clicked New Connection, then I chose Microsoft Access Database File (OLE DB). Under the Database file name, I clicked browse and selected the appropriate file(Employees.accdb). When I press Test Connection or Ok I get this error: Unrecognized database format' C:.....\Employees.accdb. Any ideas as to what I am doing wrong?

like image 572
0000 Avatar asked Apr 18 '14 18:04

0000


People also ask

How do I fix Microsoft Access Unrecognized database format?

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 repair my accdb database?

Open the Access application. Select the Database Tools tab. Then click the Compact and Repair Database option on the tab. A Database to Compact From window will then open from which you can select a database file to repair.


1 Answers

Your computer is missing Microsoft.ACE.OLEDB.12.0

You can get it from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255

like image 188
0000 Avatar answered Sep 20 '22 16:09

0000