Restoring links

U

ubu

What's the best approach for checking links on the
frontend when opening a database?
 
J

JSand42737

"ubu" said:
What's the best approach for checking links on the
frontend when opening a database?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One Note links "error message 0
Re-install office 2019 1
Converting URLs in comments to Markdown-formatted links 2
Automate Import of Spreadsheet to Backend from Frontend 1
Generate a new backend 2
Hyperlink fails to open on the first click 0
Linked tables 1
Split database- linking tables 2

Top