Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Linking Access tables from Oracle
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 Sat Jul 10 1999 - 13:16:14 CDT