Article ID: 271177 - View products that this article applies to.
This article was previously published under Q271177
This article has been archived. It is offered "as is" and will no longer be updated.
Using the Microsoft Access ODBC driver, you can repair or compact a Microsoft Access database. This functionality is accessable from the ODBC Control Panel, through the ODBC Microsoft Access Setup dialog box. This repair and compact functionality works correctly for non-password protected databases. However, when you attempt to repair or compact password protected databases, the repair or compact fails with the following error message:
Not a valid password
This problem is fixed in the latest service packs for Windows 2000 and MDAC 2.5.
Date Version Size File name Platform -------------------------------------------------------- 08/29/2000 4.0.5629.0 270,608 Odbcjt32.dll x86
One workaround is to use the JetComp tool that is included with Microsoft Jet 4.0 Service Pack 4. JetComp is a standalone tool that allows you to repair and compact a Microsoft Access database, even if Microsoft Access is not installed on the computer.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft Data Access Components 2.5 Service Pack 2 and Microsoft Windows 2000 Service Pack 2.
Steps to Reproduce Behavior
"Not a valid password"
REFERENCESFor additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/270638/EN-US/ )BUG: Database Compaction with SQLConfigDataSource Fails when Access Database is Password Protected
Article ID: 271177 - Last Review: February 28, 2014 - Revision: 3.1