variable path for back end

G

Grip

Is there a way to make a variable path for a back end? I'd like to
keep the front and back ends in the same folder and be able to move
that folder around from machine to machine without having to re-link
the tables every time it moves.

Thanks,
G
 
D

Dirk Goldgar

Grip said:
Is there a way to make a variable path for a back end? I'd like to
keep the front and back ends in the same folder and be able to move
that folder around from machine to machine without having to re-link
the tables every time it moves.
Click to expand...


You can't store a relative path in the tabledefs' Connect properties, but
you can run code on startup to relink the tables. See this link:

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