Automatically re-connect linked tables

[KPR]

Hello,
I've just split a database (d.mdb = data and a.mdb = front end). As both
..mdb files will always be together in the same folder, I would like the
linked file path reference in the a.mdb database to dynamically point to the
current folder where the databases are currently located. What I need to do
is be able to move the databases wherever I want and never have to go in and
re-link tables.

Thanks,
Ken

 

[Larry Daugherty]

I believe that some of the Ken Getz code at www.mvps.org/access will
do that for you.

HTH

 

[Peter Hibbs]

Ken.

Have a look at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'
which may be of interest.

Peter Hibbs.