John W. Colby
jwcolby at colbyconsulting.com
Mon Feb 9 07:38:05 CST 2004
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