Xref: alice comp.databases.ms-access:297429 comp.databases.oracle.server:56297 Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!blackbush.xlink.net!news-kar1.dfn.de!news-han1.dfn.de!newsserver.rrzn.uni-hannover.de!not-for-mail From: karsten reincke Newsgroups: comp.databases.ms-access,comp.databases.oracle.server Subject: Re: Linking Access tables from Oracle Date: Wed, 07 Jul 1999 09:23:47 +0200 Organization: isiv Lines: 45 Message-ID: <37830083.C4507E28@cl-ki.uni-osnabrueck.de> References: <37828FE9.E27C4F12@yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5 i586) X-Accept-Language: en To: s 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 > . > 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@cl-ki.uni-osnabrueck.de