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

Hi David

Thanks! Of course I hoped you had solved it but any info is useful.

My client is running A97 but I'm not sure that makes much of a
difference regarding this.
Tell me please, are you running the frontends as separate copies on the
workstations or are you sharing one copy on the server? I ask because
I've done the strange observation that when running a shared copy the
locking issue seems rare ... it doesn't make sense, I'll have to test
further here.

/gustav


> Dear Gustav
> We haven't cracked this one yet, it works most of the time and we've had other priorities.
> The refresh I referred to was a simple Shift-F9 on the form.  That proved to only sometimes work, as did repairing and or compacting only sometimes loosen the lock.  Only the memo fields lock.  
> It may be related to running a second A2003 database simultaneously, I am not sure.
> The best fix when all else fails seems to be shut down both databases and reopen.  (!)
> Lastly the problem seems to only occur when you have a record you want to urgently edit.   Actually that may be significant, it never is a new record, it is always an existing memo that is being
> edited and attempted to save.
> Our problem occurs running A2003 on a W2003 Server.
> I am sorry I am not able to be more helpful, at this juncture.
> Kind regards
> David Hingston MB ChB MBA
> Director
> Chequers Software Ltd
> Wellington, New Zealand.
> http://www.cheqsoft.com
> CheqSoft is associated with the Technology Entrepreneur Centre 


>   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