D Daniel Pineault Apr 30, 2008 #2 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.
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.
D dch3 Apr 30, 2008 #3 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.
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.
