Setting Link Tables Path

[Nick]

Hi,

I'm currently having two mdb files with one contains all the tables
and the other contains the link tables to the first mdb. Whenever I
tried to move both files to a different computer to work with I would
have to delete all the link tables in the second mdb and recreated
them because the path is not correct. Is there any way that I can
create link tables with relative path instead with the default
absolute path?

Thank you.

 

[Van T. Dinh]

I am not aware of relative path for linked Tables but you
can easily re-link Tables with code.

See The Access Web:

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

HTH
Van T. Dinh
MVP (Access)