copying a recordset

[99mel]

I have opened an ADODB recordset which is retrieving data from a SQL db.

All i want to do is copy that recordset to a new recordset like the following

Set myrs = sqlrs


but!! when i close the sqlrs it also closes myrs ????

Any help much appreciated

 

[MikeCox]

Try this:

Set MyRS = SQLRS.Clone

Good luck!

-Mike
Any man willing to sacrifice liberty for security deserves neither liberty nor security.

-Ben Franklin

 

[MLK]

Hi 99mel, You can also set the CursorLocation property of the first recordset to adUseClient and when you close it, the second recordset will be disconnected and you can use it as you see fit. Good Luck MLK