I inherited a database created by another person when we had Access 2003 SP2. Everything worked fine. Now we have been re-imaged with SP3. All of a sudden on a main form two drop down boxes are not populated. When investigating, I saw that when I open the back end database I now get this error
Compile Error: Can't find project or library
The code that is highlighted is this
Private Sub Form_Load()
Dim intVal As Integer
Dim strDBType As String
DoCmd.Hourglass True
intMaxAttempts = 3
intMaxMinutes = 10
strComputerName = Environ("Computername")
strComputerLogin = NetUserID
'prevent access to database window and F11 if mde
strDBType = LCase(Right(CurrentDb.Name, 3))
If strDBType = "mde" Then
intVal = ChangeProperty("AllowByPassKey", dbBoolean, False)
intVal = ChangeProperty("AllowSpecialKeys", dbBoolean, False)
End If
'destroy links to database containing audit trail
DestroyLink "FormTracking"
DestroyLink "FieldTracking"
DoCmd.Hourglass False
End Sub
Can anyone help me with this?