Link Error: several table with that name...

[ielamrani]

Hi,
I can't link tables to a an access database. Everytime I tired I get the message:

There are several tables with that name. Pleae specify owner in the format' owner.table

I search the internet but did not come up with a solution.

Anyone who fixed this problem before please let me know how.

The database I am trying to link to is an Oracle.

Thanks in advance.

 

[SydneyGeek]

Most enterprise systems contain multiple databases. It's not unusual for tables in the different databases to have the same name; for example, accounts.
To differentiate them you need to use the syntax databaseName.tableName (eg, reporting.accounts instead of journal.accounts -- and it may be necessary to use serverName.databaseName.tableName

Hope that helps

Denis

 

[ielamrani]

I'll try it. thank you so much.