How to Solve Unrecognized Database Format Access 2013

When using Microsoft Access, sometimes you may encounter some problems such as Unrecognized Database Format Access 2013. When you open the Unrecognized Database, you will getting this error message: “Unrecognized database format: (the file path)file.accdb”.

There are several reason how this happen:

  1. Different file version: Even through the file format is same (.accdb or .mdb), in some cases the newer Microsoft Access version cannot open the file from previous version and vice versa.
  2. Corrupted database: the cause is various. Could be from Virus, Improper save or shutdown, or probably force to exit the program.
  3. In case if you get the error when trying to connect it with C# program, it may be because you’re missing a driver.

Depends on the source, there are some way to fix the problem.

Older Ms Access File Version

This method is only if you try open the older file version. Run Access 2013 in service pack.

1. Right click the Access icon, then select Properties.

2. Go to Compatibility tab. Tick the Compatibility mode checkbox.

3. In Drop down menu, choose the Service Pack.

Depends on the file version, sometimes you may download and install additional service pack. If you tried to open the 2007 version, you can download the Access Runtime Service Pack 3 for free at Microsoft.

Read Also:  MS Access Case Statement Syntax in Multiple Conditions

Corrupted Ms Access File

This is for corrupted file. Access has Inbuilt Repair Utility. To do this, open the corrupted file. Then go to Database tab > click Compact and Repair Database

If the database cannot be opened, you still can use this method. All you need is to download another fixing tool, the most popular is JETCOMP tool or Access Recovery Tool. With the tool, you can repair the database without opening the file.

However please note that this method is only fixing the database, table, and query. Other objects like form or report cannot be repaired, but you can recreate it.

Ms Access Legacy Change

Change the legacy status. To do this, go to File > Options > General > Creating database > New database sort order. Change the value from the drop down menu to General – Legacy status.

Missing Driver Problem

This is the fix for missing driver. You only have to download and install a driver called Microsoft.ACE.OLEDB.12.0 from Microsoft website.

Moreover, this one is not fix but an advice. When you working with Access and other database application, make sure to do periodic backups for safety.

Related Access Database

  • criteria and syntax in MS Access 2016
  • unrecognized database format 2013
  • unrecognized database format access 2016
  • unregonised database format access 2013
Read Also:  MS Access Data Types and Properties


Access Database Tags: #unrecognized database format accdb access 2016 #unrecognized database format accdb c# #unrecognized database format access 2003 #unrecognized database format access 2010 #Unrecognized database format access 2013 #unrecognized database format access 2016 visual studio 2015 #unrecognized database format mdb #unrecognized database format vb6 #unrecognized database format visual studio 2015

Ms Access Subquery in Select Statement Syntax
Ms Access Subquery in Select Statement Syntax
Ms Access Subquery syntax is the Select
MS Access Tab Control in Form Tables or Subform
MS Access Tab Control in Form Tables or Subform
Access Tab Control is mainly used in
MS Access Left Function in SQL Query and VBA Code
MS Access Left Function in SQL Query and VBA Code
Ms Access Left Join function or sometimes


Must read×

Top