Jim Dettman
jimdettman at earthlink.net
Sat Jun 5 07:29:45 CDT 2004
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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com