[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