Dear Developers,
I am completely lost in the meaning of this error, can anyone share what's behind this mystery message?
Let me briefly describe my situation: I am having Access 2003 (format Access 2000) database, split to FE and BE running under Win7 64bit, each user has 2GB memory, intel xenon X5656 CPU (2.67 ghz).
Time to time, when users works for longer time with database (e.g 2hours not continuously as they are switching to SAP and etc.) and try to exit the form via button he received this message and the only way how to close the form is to end application and process via task manager. However, user can switch already opened forms and run some VBA codes such as export through transfershet method and etc. Access do not highlight any row in the code and if you end Access via Task manager and go to the form and exactly the same record you can exit without any problem.
Can you please help me? Any hint, idea is highly welcome...
here is the code:
On Error GoTo errorhandler
Me.Refresh
DoCmd.SetWarnings False
DoCmd.OpenQuery "<UpdateQry>", acNormal, acEdit
DoCmd.Close acForm, "<form name>", acSaveNo
errorhandler:
If Err.Number <> 0 Then
MsgBox "Error " & Err.Number & ": " & Err.Description & " in " & VBE.ActiveCodePane.CodeModule, vbOKOnly, "Error"
End If
I am completely lost in the meaning of this error, can anyone share what's behind this mystery message?
Let me briefly describe my situation: I am having Access 2003 (format Access 2000) database, split to FE and BE running under Win7 64bit, each user has 2GB memory, intel xenon X5656 CPU (2.67 ghz).
Time to time, when users works for longer time with database (e.g 2hours not continuously as they are switching to SAP and etc.) and try to exit the form via button he received this message and the only way how to close the form is to end application and process via task manager. However, user can switch already opened forms and run some VBA codes such as export through transfershet method and etc. Access do not highlight any row in the code and if you end Access via Task manager and go to the form and exactly the same record you can exit without any problem.
Can you please help me? Any hint, idea is highly welcome...
here is the code:
On Error GoTo errorhandler
Me.Refresh
DoCmd.SetWarnings False
DoCmd.OpenQuery "<UpdateQry>", acNormal, acEdit
DoCmd.Close acForm, "<form name>", acSaveNo
errorhandler:
If Err.Number <> 0 Then
MsgBox "Error " & Err.Number & ": " & Err.Description & " in " & VBE.ActiveCodePane.CodeModule, vbOKOnly, "Error"
End If
