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: Viewing a Oracle table in Access (problem)

Re: Viewing a Oracle table in Access (problem)

From: Rod Barrand <barrandr_at_clark.net>
Date: Sat, 9 Dec 2000 07:47:52 -0500
Message-ID: <rWpY5.4496$Sl.232656@iad-read.news.verio.net>

Is the table a synonym or an actual table name <anderw2_at_my-deja.com> wrote in message news:90r1rg$mmo$1_at_nnrp1.deja.com...
> I am trying to view an Oracle table from MS Access. I have made a ODBC
> connection to our Oracle database.
>
> In MS Access I select New Table then Link Table. I select ODBC
> Databases() in the File Type pull down. Then select the Machine Data
> Source Tab, click on my ODBC connection and click OK. I log into the
> Oracle database and select a table.
>
> But then I get a error (There are several tables with that name.
> Please specify the owner in the format 'owner.table')
>
> Does anybody know what that means or how to get around it?
>
> Thanks,
> Wade
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Dec 09 2000 - 06:47:52 CST

Original text of this message

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