ACC2002: Error Message: "Cannot Perform This Operation" When You Compact a Database by Using the ODBC Administrator (275074)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q275074
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you use the ODBC Data Source Administrator to compact an Access database, you may receive the following error message if Version 3.x is selected under Format:
ODBC Microsoft Access Driver Login Failed

Cannot perform this operation; features in this version are not available in databases with older format.

CAUSE

Access 2000 and later databases use the Jet 4.x database format. By default, the Database to Compact Into dialog box is set to Version 3.x. If you do not change this setting, an attempt is made to compact the database using the wrong Jet version, which results in the error.

RESOLUTION

Select Version 4.x (Jet 4.x) when you compact an Access database by using the ODBC Data Source Administrator.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

If you choose to compact an Access 97 database with this driver and use the default format of Version 3.x (Jet 3.x), the compact is successful, and you receive the following message:

ODBC Microsoft Access Setup

Database path and name to source database was successfully compacted into path and name to target database.mdb.

Steps to Reproduce the Behavior

  1. Create a system DSN with the Microsoft Access driver.
  2. In the ODBC Microsoft Access dialog box, Click Compact.
  3. In the Database to Compact From dialog box, select the sample database Northwind.mdb. Click OK.
  4. In the Database to Compact Into dialog box, type NWTest.mdb in the Database Name box.
  5. Under Format, verify that Version 3.x is selected, and then click OK.

    Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kberrmsg kbpending KB275074
©2003 Microsoft Corporation. All rights reserved.