Microsoft KB Archive/275074

= ACC2002: Error Message: &quot;Cannot Perform This Operation&quot; When You Compact a Database by Using the ODBC Administrator =

Article ID: 275074

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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  was successfully compacted into.

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 &quot;Symptoms&quot; section of this article.

Additional query words: pra

Keywords: kberrmsg kbbug kbpending KB275074

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.