can't open more than one recordsets with a same connection object in 'for' circle?
Then,I changed my code to below:
why does the code don't work?
Set Collection(i) = New ADODB.Recordset
Set CollectCnn(i) = New ADODB.Connection
CollectCnn(i) = PeopleCnn
CollectCnn(i).Open
Collection(i).Open Sql, Collection(i), 3, 3<error>
error message:the recordset using a connection that is closed or invalid.
why?
Thanks for any message.