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

Hi Tortise

Here's a very creative suggestion (one line link):

http://groups.google.com/groups?q=access+memo+field+lock&start=180&hl=xx-elmer&lr=&ie=UTF-8&oe=utf-8&selm=wQWg6.5003%24zl4.108091%40zwoll1.home.nl&rnum=182

/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.