Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Linking Access tables from Oracle

Re: Linking Access tables from Oracle

From: Michael Ho <infoage_at_hk.super.net>
Date: Sun, 11 Jul 1999 02:16:14 +0800
Message-ID: <37878DED.57C328BD@hk.super.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US