jwcolby
jwcolby at colbyconsulting.com
Fri May 30 11:34:12 CDT 2008
OK, now that I have my test code running... I am locking all these records, and in the USER INTERFACE (open a table and click in a record) the record is locked. I cannot edit the memo IN THE TABLE. BUT my code opens a recordset and can edit that exact same record. If (from in the table) I click records / remove Filter/Sort the edit that I just performed in the recordset shows in the memo field AND the record is STILL LOCKED looking directly in the table - I still can't edit it through the table directly. I am using DAO recordsets to perform the edit. Is there a property that I am supposed to set to cause the DAO recordset object to honor the locks? To DAO records not see the locks? This is truly strange and not what I was expecting. -- John W. Colby www.ColbyConsulting.com