how to relink backend tables in code

[pauly]

Hi, i am wondering if anyone knows how to relink, or specify the location of backend (split database) tables using code. I have been searching for this but i cant find anything, other than how to find the path of the linked tables using TableDef(tablename).
I would need this code to be run at startup to check whether a table connection exists and if not relink with the correct path.


PS: sorry if i have posted similar topics to this before, but i really need to find an answer

 

[Tim K.]

You can find how to do it in Sample db came with Access, called Orders.mdb. Look in the Module tab and find RefreshTableLinks module name.