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: karsten reincke <kreincke_at_cl-ki.uni-osnabrueck.de>
Date: Wed, 07 Jul 1999 09:23:47 +0200
Message-ID: <37830083.C4507E28@cl-ki.uni-osnabrueck.de>


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

hello;

we've realized the same scenario during the last weeks and for one time we met the same problem. but in our case we have found the fault by ourself:

in oracle any table, view and anything else is normally only reachable by that user who has created those schema-objects like tables, views and so on. so, one question is this: do you connect to the oracle-database as that user who has created (and imported) your objects or as another. if you use another oracle-user, connect as that user who has created (and imported) the objects or grant the select-, update- or insert-rights (and so on) to the other user.

       salut d'Allemagne kr



les chats cont les vrais hédonistes
et devraient être donc notre idéal.

 karsten reincke [ 0541/9696223 ]
 kreincke_at_cl-ki.uni-osnabrueck.de Received on Wed Jul 07 1999 - 02:23:47 CDT

Original text of this message

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