Record locks

[Pietro]

Hi,

I've database that has all its forms property "Record locks" set to
"Edited record...
I'm facing a big problem as users say that,although one only at the moment
is editing a record,it's locked...
Can anybody suggest a solution ?

 

[Jerry Whittle]

Do all the users have read, write, create, delete, modify permissions to the
folder(s) holding the database files? Not just the database file, but the
entire folder?

 

[Pietro]

Yes, all of them...
The problem does not occur with certain users,it happens from time to time
randomly...
I need to know,if a user is editing a certain record,can he lock ither
records,knowing that the form is set to lock edited record only...

 

[Jerry Whittle]

What version of Access? In older versions there was page level locking which
could cause locking problems if someone was editing a record on the same
"page". On newer versions you can set it to record level locking. Go to
Tools, Options, Advanced tab. Is there an option for "Open databases using
record-level locking"? If so make sure that it's checked.

What is the record source for the form that's giving you problems? If it's a
query that joins two or more tables, it's possible that's the problem.
Changing a record could lock up a record in the parent table and that could
lock any other records joined to that record. The best way to handle such
situations is with a form/subform combination.

It's also possible that one or more of your users are opening the databases
exclusively. That should cause other problems though.

Does the form have any fancy coding behind it? Maybe some code is locking
things up.

Lastly it might be a corruption issue. Running a compact and repair should
take care of it.

 

[Pietro]

Thank you so much Jerry for your detailed answer...
I'm using Access 2007,but the database format is Access 2000,I went to
Access options>Advanced.. and made sure that the option "Open databases using

record-level locking" is checked,the record source of the form is based on a query that has its source from one table only,no user is opening the database exclusively.

I've a suggestion that may work fine: Can i set the form to "no locks"
then add a field to the table and the query on which the form is bases,then
write a code in the Oncurrent event of this form:
If IsNull([lockedby]) then [lockedby]=Currentuser
If [lockedby]<>"" then Form.AllowEdits = False
By this way I'll be able to know exactly the user who locked the record
and,same time,I'll guarantie that I'll never have two users working on the
same record to avoid any conflict,please advise.