Gustav Brock
gustav at cactus.dk
Mon Aug 16 04:51:47 CDT 2004
Thanks David, I'll make a note on that. /gustav > 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 --- > 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