Also does anyone know of any decent tutorials about cursor types, locations and lock types, I didn't find the content on w3schools to helpful, and i'm not too clear on these things.
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.
Use adLockReadOnly lock type (the default) whenever possible for speed, but use adLockOptimistic when updating and deleting or adLockPessimistic if leaving a recordset open for editing which of course one shouldn't do on the Web anyway.
[JPS Note: This article didn't say it but use adOpenKeyset cursor type (and probably adLockOptimistic lock type) if adding a new record and will be wanting to get the autonumber. The adOpenKeyset instead of adOpenForwardOnly cursor type may not be needed for a DSN-less connection but definitely IS needed for a DSN connection so might as well always use it if adding a new record and will be wanting to get the autonumber.]