For this article, what happened if the recordset is returned from a command object execution like this?<BR><BR>Set Rs = Cmd.Execute()<BR><BR>http://www.4guysfromrolla.com/webtech/121298-1.shtml
I've tried it using a variety of methods (not not using the command object to execute a statement and return a recordset, mind), and the example you listed ONLY works if you use the objRS.Open() method.<BR><BR>Craig.
when you use SET RS = ObjConn.Execute(), you get a recordset with forward/readonly cursor (and not a dynamic cursor)
every day :)<BR><BR>Thanks man, I'll remember that.<BR><BR>Craig.
You can use .GetRows if you use the array approach:<BR><BR>http://www.4guysfromrolla.com/webtech/070500-1.shtml