Moving A Workbook with queries to a shared drive

[Stu]

I need to move a workbook I created ono my local (C) drive with about 80
queries to a folder on a shared drive. The queries query some tables in an MS
Access file which I would also like to move to this new folder. How do I get
the Workbook to look at the new folder for the Access tables, and will the
workbook look for my C drive for the queries? Will I have to edit all 80
queries?

 

[mike]

Stu,

I'm not sure about this because I haven't tried with anything that links
with Access, but, if it were looking at another Excel file, I would open them
both, save the data file to the new destination (assuming you can do this)
from within excel itself (in your case it would be Access), then save the
report or query file to the new location, again from within excel. This way,
excel knows where your destination to the file is and attempts to preserve
the links. I would have some hope that MS put this ability in for files
linked to an access file, but no promises. . . . Make copies, and give it a
try anyway.