Re: Linking Access tables from Oracle

The other possibility is that the table names in Oracle are mixed or lower case....In that case a describe will work, but select statements will not unless you enclose the table name in quotes - The ODBC driver will not correctly refer to the table name when it attempts to retrieve the data... If this is the case ( and it often is in tables exported from Access ) rename your tables to all upper case ....

Hope it helps,
John Greco
Oracle DBA/Application Developer
MnDOT

Michael Ho <infoage_at_hk.super.net> wrote:

>One possibility is wrong ODBC version.
>
>s wrote:
>
>> We have a user trying to link tables existing in an Oracle Database to a
>> new Access Database.
>> Using Personal Oracle 8.0.5 and Access 97.
>>
>> When doing so, she goes to the Access, selects to create an Access
>> Database, selects to get external data, connects via the ODBC
>> connection, the Oracle Tables available appear, she selects a
>> particular table and then receives the following error message:
>>
>> Microsoft Jet database engine could not find the object
>> <Owner.Tablename>.
>> Make sure the object exists and that you spell its name and path name
>> correctly.
>>
>> The problem is, the table DOES exist.....they were imported from an
>> existing Access Database to Oracle.
>> Plus, when doing a describe in Oracle, the table is there.
>>
>> Any suggestions as to why this would work?
>>
>> Thanks
Received on Thu Jul 15 1999 - 09:53:28 CDT