Article ID: 237575 - View products that this article applies to.
This article was previously published under Q237575
Moderate: Requires basic macro, coding, and interoperability skills.
Note This operation cannot be performed on Windows Me or Windows 2000 because these systems protect against system file manipulation.
Installing MDAC version 2.1 or later overwrites the Microsoft Access 97 ODBC driver with the Access 2000 ODBC driver without warning. For the reasons documented later in this article, you may want to revert to the Access 97 ODBC driver. Because both versions of the ODBC drivers have the same DLL name, you can only have one or the other installed.
Reasons for reverting to the Access 97 ODBC driver
The following articles provide a more long term solution which will not affect applications requiring the newer ODBC drivers:
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/244040/ )How to have your ODBC Jet 3.5 and 4.0 applications co-exist
247440Applications should be migrated to these solutions as soon as possible.
(http://support.microsoft.com/kb/247440/ )How to rename the Jet 3.51 ODBC drivers under Windows 2000
Article ID: 237575 - Last Review: January 6, 2006 - Revision: 5.0
Contact us for more help