Link tables Path

[Guest]

1. How can I know programmatically the path of the link tables?
2. I can re-link tables programmatically if all linked tables have the same
path. How can I re-link tables if we have more than one path, I mean if I
have linked tables to different BE and how can I get all paths.
Thanks
José

 

[Allen Browne]

A1. Read the Connect property of the TableDef.

A2.
You may be able to parse the name from the Connect property, modify it to
new path, assign the Connect Property, and RefeshLinks.

Alternatively, you may feel safer if you user a table that stores your
linked table names and the name of the appropriate back end database for
each one.

Naturally you need to test the path to each back end whenever you open your
application, to ensure they are all available.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), there are a couple of small
Access sample databases which might help. Look for "GetPathFileName2k.mdb"
and "RelinkOnOpen2k.mdb".

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L