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

  • Thread starter Thread starter Tammy H
  • Start date Start date
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.
 
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?
 
Back
Top