Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Me.Visible = False
- 'Determines if the database window is displayed
- SetProp "StartupShowDBWindow", False, dbBoolean
- 'Hide hidden and system objects
- SetOption "Show Hidden Objects", False
- SetOption "Show System Objects", False
- 'Find back end
- CheckLinkPath
- Set RS = CurrentDb.OpenRecordset("Select TableName From sysTables " _
- & "WHERE TableType = 'LINK'")
- RS.MoveFirst
- strConnect = db.TableDefs(RS!TableName).Connect
- If Not FileExists(Mid(strConnect, InStr(strConnect, "DATABASE=") + 9)) Then
- 'All is not well
- blnConnectError = True
- Else
- Do Until RS.EOF()
- If db.TableDefs(RS!TableName).Connect <> strConnect Then
- blnConnectError = True
- Exit Do
- End If
- RS.MoveNext
- Loop
- End If
Add Comment
Please, Sign In to add comment