Link error - several tables with that name

G

Guest

I tried to link to an ODBC table but got following error:

"There are several tables with that name.
Please specify owner in the format ‘owner.table’."

The table I selected was one of many that I have previously linked using:

File/Get external data/link tables/File Type: ODBC databases/Machine Data
Source tab/System type datafile

I don't know what was different about the one table I was trying to link to,
or what a owner.table is. How can I proceed to link to the one table that
gave me the above error?

Thanks
 
G

Granny Spitz via AccessMonster.com

Richard said:
I tried to link to an ODBC table but got following error:

"There are several tables with that name.
Please specify owner in the format ‘owner.table’."

Oracle?
 
G

Granny Spitz via AccessMonster.com

I have never seen this in Access Data Projects

And you never will, hon. ADPs have to use SQL Server (or versions thereof)
as the back end. ADPs don't have the flexibility that MDBs do as a front end
to heterogeneous back ends.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top