[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