variable path for back end

  • Thread starter Thread starter Grip
  • Start date Start date
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
 
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
 
Back
Top