Tortise
tortise at paradise.net.nz
Mon Feb 9 11:56:12 CST 2004
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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com