I am receiving an intermittent failure in the visual basic code below. No error message is ever issued.
When the failure occurs, one or more of the tables ends up local (imported) instead of linked. If you immediately repeat the function it will work correctly. The machine its running on is running Microsoft XP. The linked tables come from multiple separate databases created by different people.
No security workgroup is employed. Users each have their own copy of the program on standalone PCs. Data databases containing the tables that are linked in are sometimes copied from one PC to another.
Public Function ap_ReLinkTables(strDataDB As String) As Boolean
Dim strLinkDB As String
strLinkDB = gconDataPath & strDataDB