Access locking a range of records

[Guest]

I have a multi-user database (using a shared login) where there would be
approximately 20 consecutive users accessing a table of approx 10000 records.
The users access the data through a form. Both the form and the database is
set to lock records on "Edited Record".

I have an issue where Access seems to be locking a whole range of records in
the table. Anything up to 50 records could be locked, all of which are in
sequential order in the table. I have physically checked the users while this
was occurring and although there were some records open and being edited,
none of them seemed to be from the consecutive locked records.

Does anybody know why/how 50 consecutive records could be locked? The odd
part is that they're old records in the table, which shouldn't need to be
accessed by anybody.

Thanks.

 

[Guest]

Access lock record by page, not by one record, that mean one page may contain
many record

"Wayne" 來函：

 

[peregenem]

Access lock record by page, not by one record

Really? This post from a few days ago says otherwise:

"The Jet OLEDBatabase Locking Mode property can be set to any of the
following values:

Page-level Locking 0
Row-level Locking 1"

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adoproperties.asp

Did you really mean Access rather than Jet? Please clarify.

 

[Guest]

Hi Wayne,

First, you should probably design an unbound search, or "drilldown", form
that your users can use to open a form with just *one* record in it's
recordset for editing. If you are allowing your users to open bound forms,
where the recordset can contain hundreds or thousands of records, this can be
a real performance hit.

Take a look at the following KB article. I think this might hold the key to
your problem:

PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60
http://support.microsoft.com/?id=306435


Also, you can use a method shown by Sir Michael Kaplan, in a post he just
made earlier today on his blog site, to determine if you opened the BE
database with page or record level locking. See this:

http://blogs.msdn.com/michkap/archive/2005/10/19/482694.aspx


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a multi-user database (using a shared login) where there would be
approximately 20 consecutive users accessing a table of approx 10000 records.
The users access the data through a form. Both the form and the database is
set to lock records on "Edited Record".

I have an issue where Access seems to be locking a whole range of records in
the table. Anything up to 50 records could be locked, all of which are in
sequential order in the table. I have physically checked the users while this
was occurring and although there were some records open and being edited,
none of them seemed to be from the consecutive locked records.

Does anybody know why/how 50 consecutive records could be locked? The odd
part is that they're old records in the table, which shouldn't need to be
accessed by anybody.

Thanks.