In my asp(vbs) recordset can not move among the records but only forward even if I have as cursortype the adOpenDynamic option. For the same reason, I suppose, the RecordCount Property doesn't work. Why is this happen?
Cursor & LockType Performance Report - 6/27/1999 http://www.4guysfromrolla.com/webtec...3.report.shtml
Test was done for inserting recs instead of just getting them.
Use adOpenForwardOnly cursor type (the default) whenever possible for speed, but use adOpenStatic if want to use objRS.MovePrev or objRS.RecordCount.