[AccessD] Record locking bug

Bob Hall rjhjr at cox.net
Fri Jun 4 22:18:44 CDT 2004


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



More information about the AccessD mailing list