update link tables location

Blackie · Jan 22, 2004

I've a frontend database with tables linked to a backend database.
How can I update the linked tables locations, programatically (and DAO), each time the frontend database is open ?

Cheryl Fischer · Jan 22, 2004

There is code at the following link that will do that:

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

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Blackie said:
I've a frontend database with tables linked to a backend database.
How can I update the linked tables locations, programatically (and DAO),

each time the frontend database is open ?