Guest User

Untitled

a guest
Mar 21st, 2018
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. Dim tdf As DAO.TableDef
  2. Dim userName As String, myPassword As String
  3. Dim thisDB As DAO.Database
  4. DoCmd.SetWarnings False
  5. DoCmd.Hourglass True
  6.  
  7. Set thisDB = CurrentDb
  8. RemoveInvalidRelationships "Linked_FSE_List_Field_Service_Request"
  9.  
  10. For Each tdf In CurrentDb.TableDefs
  11.  
  12. If Left(tdf.Connect, 3) = "ACE" Then
  13. tdf.RefreshLink
  14. End If
  15. Next
Add Comment
Please, Sign In to add comment