could not update; currently locked. i don't know why?

[Azac]

hi,

I have a Access 2007 database, split in FE and BE.
Each user (about 15-20) has his own Front-End.

The database worked 2 month very well, but suddenly a runtime error occurs: " Could not update; currently locked "
Access freezes and the user can't do anything.

The error occurs irregularly, sometimes once a day, sometimes once an hour.

Users only type in the data and save the record. They can't edit or delete a record.

i change the DataEntry Property to "YES" and the recordLock property to "NO LOCK"

When the Error occurs the debugger marks this line of the code :

Private Sub Form_Current()

 
Me.txtUser = DLast("username", "tbl_user")

    
End Sub

The user gets a log-in form when he starts the database and the name is the saved in the local table "tbl_user".

I use this username to brand the record to each user.

I don't know how to find the failure. I hope someone can help me.

If you need more informations please tell me.

Thank you

 

[Azac]

Nobody here, who can help me with my problem?

Any advice how i can find my error on the database?

thanks a lot

 

[dhookom]

I'm not sure why you are setting the value of txtUser like this. You could try set its DefaultValue property when the form is opened.

Duane
Hook'D on Access
MS Access MVP