Access Record Locking Confusion

I

ions

Access User

Local time

Yesterday, 18:04

Joined

May 23, 2004

Messages

875

• Oct 6, 2006

• #1

In OPTIONS -> Advanced I have the option Open Database using Record-Level locking ticked.

What is strange is record level locking works on Form1 (Form1.recordlocks= Edited) as long as Form2 has Form2.recordlocks = No Locks. If I change the Form2.recordlocks = Edited, Form1's locking becomes page level locking.

This is even true if Form2 is not open...

Additionally, Form2's locking is always page level locking if Form2.recordlock = edited.

I would like all my forms to perform RECORD level locking not page Level locking. How do I accomplish this.

I've been trying to resolve this issue for about 2 months now but no answers from the community.

Thanks for any comments.

 

KeithG

AWF VIP

Local time

Yesterday, 18:04

Joined

Mar 23, 2006

Messages

2,591

• Oct 6, 2006

• #2

I have been trying to resolve the same issue. I read in the Microsoft knowledge base that if the user opens the database by a shortcut or by clicking the .mdb file that the database will open with Page level locking instead of Record level locking. They say a work around for this is to open up the Microsoft Access program (not an actual database just the program) and select File/Open and then navigate to your database and open it up. What version of Access are you using?

 

I

ions

Access User

Local time

Yesterday, 18:04

Joined

May 23, 2004

Messages

875

• Oct 6, 2006

• #3

Hi Keith G .. I will test that out. I am using Access 2002.

 

gemma-the-husky

Super Moderator

Staff member

Local time

Today, 02:04

Joined

Sep 12, 2006

Messages

16,075

• Oct 7, 2006

• #4

Even if you use record-level locking, Windows will actually lock the page(s) in which the record resides, which will probably also lock neighbouring records. Look in "locking records" in Access help. Is this happening here?

 

I

ions

Access User

Local time

Yesterday, 18:04

Joined

May 23, 2004

Messages

875

• Oct 11, 2006

• #5

Hi Pat.

I am using Access 2002. I seem to be getting Record Level Locking on some forms Pat.

 

I

ions

Access User

Local time

Yesterday, 18:04

Joined

May 23, 2004

Messages

875

• Oct 18, 2006

• #6

Hmmm, you are right. I assumed the records were located on the same page / segment because they are stored next to each other in the table.

So basically that record level option doesn't work? Record level locking is not achievable in Access 2002?

 

Steve R.

Retired

Local time

Yesterday, 21:04

Joined

Jul 5, 2006

Messages

5,439

• Oct 18, 2006

• #7

This has been an irritating issue for me. I have a database that I am going to "convert" from a single user to a multisuser database. When testing as a multiuser, I get some locking, but it is erratic and I have not been able to pinpoint a cause. Just the other day, I received a message that I could not open the database, because another user was using it. They where, but I immediately retried and got in on the second attempt????????