[AccessD] Been Dazed and Confused for so long it's not true.

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



More information about the AccessD mailing list