Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Viewing a Oracle table in Access (problem)
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