Question Page file size and record locking question

[G1ZmO]

Hi,

Our split db has now grown to a fair size and is being used by around 10 people at once

We are having an increasing problem with "Could not update, currently locked" messages and we need to shout around for users to move onto a blank record in order to free it up again.

The DB FE and BE are set to:
Record locking: Edited Record and
Open Database using record-level locking

Is there a way of changing the size of the data block that Access locks?

Also is there a way to determine what size a particular record is?

When users are just sitting at the switchboard menu the fileserver (Computer management - Open Files) reports that the BE .ldb file has 4 locks - Is this 4 data pages in access (which I think is 8k) or something else? See attatched screenie.

Any other suggestions as to how to resolve the problem gladly welcomed.

Thanks

Paul

 

[The_Doc_Man]

OK, the problem might be that you are locking because people are trying to create records in the same place because it happens to be next free space. And it is locked because someone got there first. As to page-file size, this will help only the individual users as page-file is a local-machine property. Won't help the shared database that much because that database's server page file isn't the cause of the problem.

I do not know of a way to change the size of the data page. I think it is something that is hard-coded into the "build" of Access itself. Further, I don't thing changing it will make a difference if your problem is record-expansion or record-creation congestion. The "next block" is the "next block" regardless of its size.

Play with things like optimistic locking for whatever it is that your users are doing that causes the locking. Pessimistic locking is safer for data but holds locks longer.

 

[gemma-the-husky]

dont use record locking - its most unlikely to be required, and not using recotrd locking will probably fix all of your problems