Administrator
administrator at it.glasgow.gov.uk
Tue Jan 28 17:53:29 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. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd