Jim Dettman
jimdettman at earthlink.net
Tue Feb 10 08:29:10 CST 2004
Gustav, > 1. Change the Refresh Interval - Down - Shorter refreshes would release any held read locks sooner if the pages where no longer being used. Especially on indexes. Con: more network traffic and possible delays in the user interface. > 2. Change the Update Retry Interval - Up - Longer delay between retries when a lock is encountered. > 3. Change the Number of Update Retries - Up - Try more times before popping an error > 4. Changing the Recycle LVP page setting - This could go either way as it goes to the pattern of usage by the app. In some cases, recycling LVP's could help, in others hurt. I would try it both ways. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock Sent: Tuesday, February 10, 2004 9:16 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Memo Locked - Apparently, but not that I can find!!! Hi Jim Would you have any suggestions for how (up/down?) these settings could be changed? /gustav > What your probably bumping into is read locks on the LVPs (Long Value > Pages). Read locks allow multiple users to read long value data, but prevent > others from writing to it while others are reading. Starting with JET 3.0, > the persistence of read locks is determined by the currency of a record. So > a read lock on a long value page will remain until the user leaves that > record. There is an exception though; if the LVP contains multiple rows of > data JET should be releasing the lock before that. > Some things you might try: > 1. Change the Refresh Interval > 2. Change the Update Retry Interval > 3. Change the Number of Update Retries. > 4. Changing the Recycle LVP page setting > These above are all JET settings. And of course anything you can do to > get the user off the record faster would be better. Switching to Optimistic > locking (No Locks) with page locks or Pessimistic (Edited Record) with > Record Level locking might also help depending on the design of the app and > the typical patterns of usage. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com