Moving a linked .mdb

B

Bill

I have a database that I created on our network. The database is linked to
three separate sheets in a single Excel file. When I copy the .mdb and the
Excel file to my hard drive so I can work on it at home, all of the file
referneces are maintained as g:\...\... How can I change the files
references to the C: drive when I am working off the network.

Thanks
 
D

Dirk Goldgar

Bill said:
I have a database that I created on our network. The database is
linked to three separate sheets in a single Excel file. When I copy
the .mdb and the Excel file to my hard drive so I can work on it at
home, all of the file referneces are maintained as g:\...\... How
can I change the files references to the C: drive when I am working
off the network.

Thanks
Click to expand...

Use the Linked Table Manager to link the tables to the file at its new
location. Tools -> Database Utilities -> Linked Table Manager (for
Access 2000 or later -- if you're using Access 97, it's under Tools ->
Add-Ins).

If you then carry this file back to your office network, you'll have to
use the LTM again to relink the tables to the network copy of the file.
 
J

John Vinson

I have a database that I created on our network. The database is linked to
three separate sheets in a single Excel file. When I copy the .mdb and the
Excel file to my hard drive so I can work on it at home, all of the file
referneces are maintained as g:\...\... How can I change the files
references to the C: drive when I am working off the network.

Thanks
Click to expand...

Tools... Database Utilites... Linked Table Manager will do this for
you. Select the linked tables with the checkbox and click OK; when it
doesn't find them on G: you'll get a windows file dialog box to locate
them.

John W. Vinson[MVP]
 
Top