Function to check if linked tables are attached

[dch3]

Anyone have some code that tests if linked tables are currently attached?

 

[Daniel Pineault]

Try a function similar to

Function CheckLinks(strTableName as String) As Boolean
On Error Resume Next
Dim dbs As DAO.Database
Dim rst As DAO.Recordset

Set db = CurrentDb()
Set rst = db.OpenRecordset(strTableName)

If Err = 0 Then
CheckLinks = True
Else
CheckLinks = False
End If
End Function
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

 

[dch3]

And since the frontEnd will be link to two different back ends - one with the
data, one with temp files for the user, iterate through the system table with
the objects, look for connection strings and the test each table.