Error message when you try to open a compiled database file or a compiled project file in Access 2007: "This database is in an unrecognized format"

Article translations Article translations
Article ID: 946205 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you try to open a compiled database file (.accde or .mde) or a compiled project file (.ade) in Microsoft Office Access 2007, you receive the following error message:
This database is in an unrecognized format.

The database may have been created with a later version of Microsoft Office Access than the one you are using. Upgrade your version of Microsoft Office Access to the current one, and then open this database.

CAUSE

This problem occurs if the compiled database file or the compiled project file was created on a computer that has the 2007 Microsoft Office suites Service Pack 1 (SP1) installed. This problem occurs when you try to open the file that you created, and the following conditions are true:
  • You try to open the file on a computer that has the original version of Access 2007 installed.
  • The 2007 Office suites Service Pack 1 is not installed on the computer.

RESOLUTION

To resolve this problem, use one of the following methods.

Method 1

Install the 2007 Office suites Service Pack 1 on the computer on which you are trying to open the file.

For more information about the 2007 Office suites Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
936982 Description of the 2007 Microsoft Office suites Service Pack 1

Method 2

Install the hotfix package that Microsoft Knowledge Base article 943249 describes. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
943249 Description of the Access 2007 hotfix package: January 28, 2008
Note After you install the hotfix that Knowledge Base article 943249 describes, any database or project that is compiled on the computer cannot be opened on a computer that still has the original version of Access 2007 installed.

WORKAROUND

To work around this problem, create the compiled database file or the compiled project file on a computer that does not have the 2007 Office suites Service Pack 1 installed.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Steps to reproduce the problem

  1. Install 2007 Office suites Service Pack 1 on a computer.
  2. Start Access 2007.
  3. Click the Microsoft Office button
    Collapse this imageExpand this image
    Microsoft Office Button
    , and then click New.
  4. Click Blank Database, and then click Create.
  5. Click the Database Tools tab, and then click Make ACCDE in the Database Tools section.
  6. In the File name box, type a name for the file, and then click Save.
  7. On a computer that does not have the 2007 Office suites Service Pack 1 installed, try to open the file that you created in step 4.

Properties

Article ID: 946205 - Last Review: April 2, 2008 - Revision: 3.0
APPLIES TO
  • Microsoft Office Access 2007
Keywords: 
kbtshoot kbpubtypekc kberrmsg kbprb KB946205

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com