Moving a linked .mdb

[Guest]

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

 

[Dirk Goldgar]

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

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.

 

[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

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]