Administrator
administrator at it.glasgow.gov.uk
Wed Jan 29 03:49:30 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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd