Linked tables pointing to old domain

[zim]

Hello. I am an Access 2000/2002 newb, so my apologies. I installed a new
server for one of our clients, and transferred their Access databases to it.
The databases with "linked tables," include the old server's computer name
in the link, even though the databases reside on a new server. The databases
with the old links are not working because they can't find the old server.
How do I update these links to reflect that the database is on a new server?

Thanks!

pk

 

[Rick Brandt]

Hello. I am an Access 2000/2002 newb, so my apologies. I installed a new
server for one of our clients, and transferred their Access databases to it.
The databases with "linked tables," include the old server's computer name
in the link, even though the databases reside on a new server. The databases
with the old links are not working because they can't find the old server.
How do I update these links to reflect that the database is on a new

server?

Linked Table Manager will allow you to refresh the links as well as point
them to a new location while doing so. It's under database utilities.