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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UNC path network performance 1
Change path linking front and back ends? 2
Splitting database - Back end loses directory path 4
Any way to make relative links? 3
Can I move a Front/Back End to a laptop? 10
Open Back End Folder 10
Update back-end tables, fields, relationships etc... 6
Backup of back-end db 4

Top