Tortise
tortise at paradise.net.nz
Tue Mar 16 12:19:28 CST 2004
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 Crafters of iconic system tray software: => Break Reminder - for safe and efficient PC use => TimesOwn - multi time zone clock and calculator => Clipboard Express - drag n drop database saves serious time => MP3Detective - MP3 player manager => Engines2go - faster Internet searching ____________________________________________________________ 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 10: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