can you open more than one recordset with the same connection to a database IF YOU CLOSE ONE RECORDSET AND OPEN ANOTHER rather than creating a connect object each time you open a different record?
In fact, you'd much prefer to do this. Think of it: one connection obj & two recordsets or two conn obj and two recordsets? Which one uses less resources & runs faster? - the one with the fewer objects of course.<BR>