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?
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.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With