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

  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.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tortise
Sent: Monday, February 09, 2004 9:28 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Memo Locked - Apparently, but not that I can
find!!!


mmm
Seems Shift F9 is not the full answer.  It worked once...only....
Is there some way to unlock a memo which is erroneously locked???
Kind Regards
David
----- Original Message -----
  From: Tortise
  To: Access Developers discussion and problem solving
  Sent: Tuesday, February 10, 2004 6:56 AM
  Subject: Re: [AccessD] Memo Locked - Apparently, but not that I can
find!!!


  Thanks John,
  That gave me enough to resolve it.
  Also Ref http://www.utteraccess.com/forums/access/access605200.html
  For anyone else simply doing a refresh unlocks it!
  Kind Regards
  David
    From: John W. Colby
    To: Access Developers discussion and problem solving
    Sent: Tuesday, February 10, 2004 2:38 AM
    Subject: RE: [AccessD] Memo Locked - Apparently, but not that I can
find!!!


    Memo fields are treated differently than the rest of the fields in a
record.
    They are simply pointers out to a storage area where the actual memo is
    stored.  Memos still have the "page locking" issue where if another user
is
    editing another memo that resides in the same physical page as your
memo,
    yours will be locked.

    John W. Colby
    www.ColbyConsulting.com

    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com
    [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tortise
    Sent: Monday, February 09, 2004 5:24 AM
    To: Access Developers discussion and problem solving
    Subject: [AccessD] Memo Locked - Apparently, but not that I can find!!!


    Hi
    I have a database which intermittently reports memo fields as being
locked.
    However they are not!  Editing the memo field it refuses to update on
    attempted save, however text fields still update fine. (!)  It is a
database
    from A2K, that went to A97, back to A2k and now is running (converted)
in
    A2k3.  (Over time!)  Repair and compaction makes no difference, neither
does
    logging off and back on to the windows session.
    The same behaviour is exhibited when editing the table as it is from a
form.
    I'm stumped!
    As always any guidance is appreciated.
    Kind Regards
    David
    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com


    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com