Multiple Users - database locking

[Neekos]

I have a database that uses a combobox as the main screen. employees choose the duty they are working on from the combo box, which in turn opens the related form for each duty. Occasionally, when users are doing the same duty, the database locks and gives an error stating "cannot update record - record currently locked". I have the forms set as DataEntry, thinking that it would always go to a new record and prevent that error, but its still happening.

How do i properly handle multiple users?

[mshmyob]

Programming for multi users is a big topic. But it sounds like you have Pessimistic locking on. You may want to turn on Optimisstic locking.

Under Options you can set your record locking settings.

Also check the Record Lock setting on your form. Set it to No Locks.

I have a database that uses a combobox as the main screen. employees choose the duty they are working on from the combo box, which in turn opens the related form for each duty. Occasionally, when users are doing the same duty, the database locks and gives an error stating "cannot update record - record currently locked". I have the forms set as DataEntry, thinking that it would always go to a new record and prevent that error, but its still happening.

How do i properly handle multiple users?

[Neekos]

i have the record locking set to "no locks". I also have the database split - forms on their computers, tables on the server.

Where do i change optomistic/pessimistic locks? or is that the same as the "no locks" option?

It worked fine yesterday - this morning i came in and they said it locked up on them again.

Any ideas?

[mshmyob]

What version of Access are you using?

i have the record locking set to "no locks". I also have the database split - forms on their computers, tables on the server.

Where do i change optomistic/pessimistic locks? or is that the same as the "no locks" option?

It worked fine yesterday - this morning i came in and they said it locked up on them again.

Any ideas?