Microsoft KB Archive/295172

= The Oracle table name must be in uppercase characters when you link to the Oracle table in Access 2000 =

Article ID: 295172

Article Last Modified on 2/20/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition
 * Microsoft Data Access Components 2.1 Service Pack 2
 * Microsoft Data Access Components 2.6
 * Microsoft Data Access Components 2.6 Service Pack 1

-



This article was previously published under Q295172



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
You can link a table from an Oracle 8 relational database management system (RDBMS) to a Microsoft Access 2000 database. However, if the Oracle table name is not in uppercase characters, you receive the following error message:

The Microsoft Jet database engine could not find the object ' .Shippers'''.
 * 1) Click OK to try to link the table to the Access 2000 database.

You receive the error message that is mentioned in the &quot;Symptoms&quot; section.

Additional query words: pra linked fail

Keywords: kbbug KB295172

-

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

© Microsoft Corporation. All rights reserved.