variable path for back end

[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

 

[Dirk Goldgar]

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.

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