Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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"

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"

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Status

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

↑ Back to the top

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 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.

↑ Back to the top

Keywords: kbentirenet, kbtshoot, kbpubtypekc, kberrmsg, kbprb, kb

↑ Back to the top

Article Info
Article ID : 946205
Revision : 1
Created on : 1/7/2017
Published on : 4/2/2008
Exists online : False
Views : 179