Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Linking Access tables from Oracle
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