Susan Harkins
harkins at iglou.com
Fri Jan 31 23:31:00 CST 2003
I think this one got lost this past weekend.
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, and it acts appropriately (as
inconsistent) without explicitly setting the property using
.Properties("Jet OLEDB:Inconsistent") = False
With rst
.ActiveConnection = CurrentProject.Connection
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Open strSQL
Anyone know what's going on -- either the documentation's wrong (surprise)
or there's more to what determines the property's default.
Susan H.