re-linking tables

[Hugo Lefebvre]

I have a back-end and a front-end database. The tables of the back-end
database are linked in the front-end database. Both databases are in the
same map.

Problem is: the back-end database has to be always on the same location
(e.g. c:\test). What I want is that the tables are automatically re-linked
(and if not automatically, by running a procedure), if I move both databases
to another place.

In other words: I look for a procedure that links all the tables of the
back-end database in the front database, supposing that both databases are
in the same map.

Thanks for help
Hugo

 

[Tim Ferguson]

Problem is: the back-end database has to be always on the same
location (e.g. c:\test). What I want is that the tables are
automatically re-linked (and if not automatically, by running a
procedure), if I move both databases to another place.

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


Hope that helps


Tim F

 

[Guest]

See my second post in "create a link to a file" in this news group.

 

[jacksonmacd]

The relinker that I use was developed by Carl Tribble. You can find it
in the "Useful files" section of http://www.colbyconsulting.com

Look for the file named ALink21

I have a back-end and a front-end database. The tables of the back-end
database are linked in the front-end database. Both databases are in the
same map.

Problem is: the back-end database has to be always on the same location
(e.g. c:\test). What I want is that the tables are automatically re-linked
(and if not automatically, by running a procedure), if I move both databases
to another place.

In other words: I look for a procedure that links all the tables of the
back-end database in the front database, supposing that both databases are
in the same map.

Thanks for help
Hugo

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Educo Gent]

thanks !!! it works !!

Hugo

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


Hope that helps


Tim F

 

[Educo Gent]

thanks !!
hugo

See my second post in "create a link to a file" in this news group.