U
ubu
What's the best approach for checking links on the
frontend when opening a database?
frontend when opening a database?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JSand42737
"ubu" said:What's the best approach for checking links on the
frontend when opening a database?
You need to loop through the TableDefs collection, checking the .Connect
property of each. If this string exists, then the table is linked, and you can
extract the target datasource, and check for its existence. There is some
sample code on the Access Web that deals with reconnecting to datasources:
http://www.mvps.org/access/tables/tbl0009.htm
http://www.mvps.org/access/tables/tbl0010.htm
http://www.mvps.org/access/tables/tbl0012.htm
J
John Nurick
U
ubu
That's Pere Ubu to you. Thanks for the response.
-----Original Message-----
Hi Ubu,
How's the kingdom?
See http://www.mvps.org/access/tables/tbl0009.htm
What's the best approach for checking links on the
frontend when opening a database?
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.