Records Locked by user

[fredk]

I had posted a few weeks ago regarding this but still have been unable to figure out my problem.

I have a database where the backend (access) data is on a shared drive. Each user has their own front end on the shared drive also. Because I do not yet totally understand the security feature in setting up users/groups/permissions... I have not security other than the folder on the shared drive is limited to those using the database. Therefore, everyone signs in as admin. This will be a future fix, but for now its what I have.

The problem is there is now times when one user will lock the records - Anyone else who trys to save a record gets a message that the record is locked by another user -

This seems to happen when one user has saved a record but not moved to another record.

I don't have any code that uses the recordset - Any suggestions/help would be greately appreciated! Thanks!!!

Fred

 

[KenReay]

Hi

Hi

It may be a genuine lock.

You can select pessimistic or optimistic locking

Pessimistic locks when the user starts to edit a record

Optimistic locks when the user actually updates (saves) the record

Also Access97 does page locking not row (record) locking, so updating a single row may actually lock several rows

Access2K and XP have the option to use row level locking but I believe the default is page locking Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[fredk]

Thanks Ken - That would explain why someone trying to add a new record is being locked out.

Is there anything I can do to modify this? The strange thing is it just started happening recently.

Thnaks!!!!!