[AccessD] Record locking bug

>With the database window open, go to Tools;Options;Advanced and make sure
"Open databases using record level locking" is checked.

Has always been set, still is.

>Access will still use page locking when:

>Bulk updates w/SQL.

I am just manually editing (through a query) a single record in the case of
this bug demo.

>Updating memo fields.

I intentionally deleted the only memo field in the table to ensure this
wasn't it.  That wasn't it.

>Using ADO w/ lock granularity set to 1.

Not using ADO, just manually editing the record through a query.

>Updating indices.

Hmmm... I am updating a FK field that of course has an index.  I just
removed the index on this field, saved the tables, and tried again, still
getting the locking of surrounding records.


John W. Colby 
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Saturday, June 05, 2004 8:30 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Record locking bug


Bob,

 Sorry for repeating what you said.  Just goes to show that I need to take
the time to read the entire thread before I stick my .02 in.

Jim Dettman
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bob Hall
Sent: Friday, June 04, 2004 11:19 PM
To: AccessD
Subject: Re: [AccessD] Record locking bug


On Fri, Jun 04, 2004 at 10:37:39PM -0400, jwcolby wrote:
> I think I have stumbled on a record locking bug.

With the database window open, go to Tools;Options;Advanced and make sure
"Open databases using record level locking" is checked.

Access will stil use page locking when:
Bulk updates w/SQL.
Updating indices.
Updating memo fields.
Using ADO w/ lock granularity set to 1.

That's the obvious stuff. Hope it helps.

Bob Hall