Susan Harkins
harkins at iglou.com
Tue Jan 28 17:00:50 CST 2003
Documentation leads me to believe that even a dynamic ADO recordset is consistent by default. However, I just checked and rst.Properties("Jet OLEDB:Inconsistent") returns True. I'm confused. What I'm reading is assuming the OpenRecordset method and I used Open in the form With rst .ActiveConnection = CurrentProject.Connection .CursorType = adOpenDynamic .LockType = adLockOptimistic '.Properties("Jet OLEDB:Inconsistent") = False .Open strSQL I have to assume that makes a difference -- can anyone explain it? Susan H.