After re-linking tables to a new server, all queries don't see upd

T

Tammy H

Please Help... I have an Access file that links to an external database.
The db was moved to a new server, I was successfull in re-linking the tables
to the new server, but all of the queries and reports fall under the
unrelated Object category. How do I re-link my previous queries and reports
to the re-linked tables. If I open the Table, any updated data is there, but
when I run the query there is no updated data.
 
J

John Vinson

Tammy H said:
Please Help... I have an Access file that links to an external database.
The db was moved to a new server, I was successfull in re-linking the tables
to the new server, but all of the queries and reports fall under the
unrelated Object category. How do I re-link my previous queries and reports
to the re-linked tables. If I open the Table, any updated data is there, but
when I run the query there is no updated data.
Click to expand...

It sounds like the name of the tables may have changed. Do they have a
server or owner prefix (such as dboMyTablename)? If so is it different in the
table window than in the SQL view of your queries?
 

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

Similar Threads

linked tables.....pre designed forms, queries, reports 1
Access freezes or hangs attempting to open linked ODBC tables 1
Opening Access 2003 over Server 2
Queries re-used problem. 2
import new data in tables 1
re-linking Access db to new updated SQL 2005 DB 3
Read only tables, but still create queries etc. 11
create one table using multiple linked tables 6

Top