How do I create a Link Table from a reference path(not full path)?

[troubledHC]

I am using Access 2000 to create a database and used the linked table manager
to create a back-end database.

Problem: Using a linked manager will create a linked that is linked with the
full path-name to the back-end. So, when I relocate the database to other
directory/pc, the linked does not work anymore. The target directory/pc might
not have the microsoft access available, so cannot use the linked table
manager to refresh the links.
Question: How do I create a link with a reference path name (example
../Data/xx_be.mdb)?

 

[Brendan Reynolds]

The path to the linked table must always be an absolute path, but you can
change the path programmatically when your app runs. There's example code at
the following URL ...

http://www.mvps.org/access/tables/tbl0009.htm