Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: Unable To Repair Password Protected Database Through ODBC Control Panel
Article ID: 271177 - View products that this article applies to.
This article was previously published under Q271177
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:
(http://support.microsoft.com/kb/270638/EN-US/ )BUG: Database Compaction with SQLConfigDataSource Fails when Access Database is Password Protected
Article ID: 271177 - Last Review: April 7, 2006 - Revision: 3.1