Fri 7 Nov 2008, 16:00Delegate Craig said...
Craig has attended:
Excel VBA Advanced course
Active X Data Objects
If you want to run multiple queries on a single connection, do you create a new recordset each time or simply write over it with the results of the next query?
Thu 27 Nov 2008, 11:29Trainer Stephen said...
RE: Active X Data Objects
Hi Craig
Thank you for your question
Either method would work OK. The main question would be whether you wanted to compare two of the queries with each other. If so then clearly you would need two recordsets, otherwise it would be OK to reuse the same recordset variable for successive queries.
Regards
Stephen
