[AccessD] Memo Locked - Apparently, but not that I can find!!!

Gustav Brock gustav at cactus.dk
Tue Feb 10 08:16:28 CST 2004


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.



More information about the AccessD mailing list