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

Tortise tortise at paradise.net.nz
Sun Aug 15 05:51:25 CDT 2004


Dear Gustav et al
This problem has been unsolved for ages, I have turned my attention to it again.
It seems to have been fixed by simply copying the memo field contents into a new memo field (same table) and addressing this new memo field instead.  Many memo records apparently locked are again free to be saved(!)  The old memos are then removed.  
I am guessing but something was corrupt in the page locking of some of the memo records, that a database repair would not fix...
Hope this helps someone else one day....
Kind regards
David Hingston 
Director
Chequers Software Ltd
Wellington, New Zealand.
http://www.cheqsoft.com

=> Engines2go - faster Internet searching
=> MP3Detective - find your MP3's fast!
=> Break Reminder - for safe and efficient PC use
=> TimesOwn - international clock and time difference calculator
=> Clipboard Express Pro - drag n drop database saves serious time
____________________________________________________________

The information in this email and in any attachment (s) is confidential and may be legally privileged. If you are not the named addressee's) or if you receive this email in error then any distribution, copying or use of this communication or the information in it is strictly prohibited. Please notify the sender immediately by return email and then delete the message from your computer. Thank you for your assistance.
____________________________________________________________



  ----- Original Message ----- 
  From: Gustav Brock 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, March 16, 2004 9:09 PM
  Subject: Re: [AccessD] Memo Locked - Apparently, but not that I can find!!!


  Hi David

  I have a client fighting with this too.

  Could you be a little more specific on your solution, please?
  What are you refreshing and when?
  Which of the advices mentioned in the forum discussion did you
  implement?
  As I read it, you update (save) the record at the BeforeUpdate event
  of the memo field, then Cancel the update and refresh (requery?) the
  record? 

  /gustav


  > 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



More information about the AccessD mailing list