Problem with Environ function in 2003 SP3

[wgreynol]

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?

[RuralGuy]

Did you just misstype when you state opening the BackEnd rather than the FrontEnd?

[ajetrumpet]

there has been issues with sp3 back to the stone age. I remember when Bob Larson posted the link about the hotfix available after the issues were discovered by industry professionals.


Here is an example KB from Microsoft about the hotfixes available and the issues that SP3 brought about: http://support.microsoft.com/kb/945674