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

Tortise tortise at paradise.net.nz
Mon Feb 9 11:56:12 CST 2004


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


More information about the AccessD mailing list