Execution of this application has stopped due to a run-time error

[akins4lyfe]

Hello all,

I have an application running on Access 2003 version, installed on a shared network folder. The database is accessible to more than 15 employees at a time. We have installed the full version of Access 2003 on all workstations. Therefore, i don't believe it's a reference or run-time application problem.

Clicking a command button, containing the code below within my program always triggers the following error. "Execution of this application has stopped due to a run-time error, Access will now terminate". access then shuts down completely on that user's machine.

Here's a sample code:

Private Sub cmdGenerateNote_Click()

On Error GoTo err_handler
If IsNull(Me.txtCompanyName) Then
MsgBox "Company Name Required", vbExclamation, "Missing Field"
ElseIf IsNull(Me.txtSingnedby) Then
MsgBox "Signatory to the notice required", vbExclamation, "Required"
Else
Call SubmitNote
Call Cleanout
Call DoubleNote

End If

endit:
Exit Sub

err_handler:
MsgBox _
"An unexpected error has been detected" & Chr(13) & _
"Description is: " & Err.Number & " , " & Err.Description & Chr(13) & _
"Module is: commandbutton_click" & Chr(13) & _
"Please note the above details before contacting your administrator"
Resume endit
End Sub

Also, this problem always occur to an employee on different machines, at different locations within the department. I have repair and compact the database, without luck. I have also import all objects into a new database, that did not work either. I deleted the whole program and designed a new one, the error just resurfaced again this afternoon.

I have no clue what I'm doing wrong.

Any suggestions, or assistance pls.

Thanks

 

[PHV]

Do you have a BE on the shared folder and a local copy of the FE on each machine ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[akins4lyfe]

hi PHV,

Thanks for your response. This database was not splitted into BE+FE, a single compiled .mdb file was installed inside a network folder.

A hyperlink of the database path, was sent to all users, to access it at the same time.

Thanks.

 

[PHV]

This database was not splitted into BE+FE
So, you know what you have to do ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886