E
Eric I
Assuming all the excel files are just linked to the Access
mdb, you should be able to move the files and then go into
the linked table manager in Access (under the tools
menu/Database utilities) and click the "always check for
new location" checkbox before clicking the select all
button. That's the manual way to handle it.
The other option would be to go through the tabledef's
collection looking at the connect property of each
tabledef. You may be able to manipulate it directly
through there with code.
mdb, you should be able to move the files and then go into
the linked table manager in Access (under the tools
menu/Database utilities) and click the "always check for
new location" checkbox before clicking the select all
button. That's the manual way to handle it.
The other option would be to go through the tabledef's
collection looking at the connect property of each
tabledef. You may be able to manipulate it directly
through there with code.