Click on add new record button and lock message appears.

[mlrmlr]

Hi,

I am so frustrated with this issue. I have a split database with no more than 5 users. I have an input form that has an Add New Record button that was generated by the wizard (code below). The function works periodically and locks up periodically. More often than not, users are receiving locked or cannot be added to recrod error messages.

Can someone shed some light on my problem or offer a suggestion around this please.

<START CODE>
Private Sub Add_New_Record_Input_Form_Click()
On Error GoTo Err_Add_New_Record_Input_Form_Click

DoCmd.GoToRecord , , acNewRec

Exit_Add_New_Record_Input_Form_Click:
Exit Sub

Err_Add_New_Record_Input_Form_Click:
MsgBox Err.Description
Resume Exit_Add_New_Record_Input_Form_Click

Thanks.
End Sub
<END CODE>

 

[Crowley16]

this is a bound form right?

access doesn't handle bound forms and concurrency well, e.g. it will lock the new record while someone is in the process of adding a new record, i.e. before the user moves onto the next record, and this will essentially lock the form so that no new records can be entered, until that user commits the new record...

have you considered using un-bound forms?

--------------------
Procrastinate Now!

 

[PHV]

I have a split database
Does each user have their own local copy of the FE ?

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

 

[mlrmlr]

Hi Crowley16 and PHV.

Crowley16, yes this is a bound form. How would I use an unbound form to record the data entered. This may be a technique I have not used before.

PHV, yes each user has their own local copy of the FE.