Queries and Reports looking at old database location

[Guest]

I've moved my users' database from one server to another but users' queries
and reports are looking for the old server. Is there a way to change the
path the queries and reports are using.

 

[Guest]

Hi Saginaw,

It sounds like you have linked tables, and these are still pointing to the
former location. If so, delete all linked tables in your front-end
application. Then do a compact and repair (Tools > Database Utilities >
Compact and repair database). Hold the shift key down while doing this, to
prevent a startup form from opening.

Then use File > Get External Data > Link Tables... to establish brand new
table links from scratch.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I've moved my users' database from one server to another but users' queries
and reports are looking for the old server. Is there a way to change the
path the queries and reports are using.

 

[Guest]

Thanks Tom. I'll try this with my users after I back up the DB.

Saginaw