Article ID: 129814
Article Last Modified on 11/6/2000
APPLIES TO
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q129814
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
When you try to attach a DB2 table containing an underscore (_) or a percent sign (%) in its name, you receive the following error message:
NOTE: This error message has been found to occur in Microsoft Access 97. The use of the ODBC driver for DB2 in Access 97 is not supported by Microsoft Product Support Services. For information regarding the use of this ODBC driver please call the drivers vendor.
CAUSE
The Microsoft Jet database engine misinterprets the underscore or the percent sign. This causes the Jet database engine to pass an incorrect table name to the DB2 ODBC driver.
STATUS
This problem no longer occurs with the 04/18/95 version of the Microsoft Jet database engine (MSAJT200.DLL). This file is available with the Microsoft Access version 2.0 Service Pack dated 05/01/95.
For information on how to obtain the updated Service Pack, please see the following article in the Microsoft Knowledge Base:
122927 WX1124: Microsoft Access Version 2.0 Service Pack
MORE INFORMATION
To find out which version of the Microsoft Jet database engine is installed on your computer, follow these steps:
- Open File Manager.
- From the View menu, choose All File Details.
- Select the Windows\SYSTEM directory to view its contents.
- Scroll through the contents of the window to find the MSAJT200.DLL file.
You may have one of the following versions of the Microsoft Jet database engine (note the version number and the size):
If you never installed the Microsoft Access version 2.0 Service Pack:
MSAJT200.DLL 2.00 994496
If you installed the Microsoft Access version 2.0 Service Pack dated 12/02/94:
MSAJT200.DLL 2.50.1108 995056
If you installed the Microsoft Access version 2.0 Service Pack dated 05/01/95:
MSAJT200.DLL 2.50.1606 995136
REFERENCES
For more information about the Microsoft Access version 2.0 Service Pack, please see the following article in the Microsoft Knowledge Base:
122927 WX1124: Microsoft Access Version 2.0 Service Pack
Additional query words: jet25 jet 2.5
Keywords: kberrmsg kbbug kbusage KB129814