Hi,
Stephen is right. Did you check that it has client side,
or you think that it has client side. Even if you set
CursorLocation of recordset to adUseClient it does not
mean that it will be opened on client side. It depends on
how you opened your recordset. If you opened it using
Execute method of Command or Connection object then cursor
location will be switched to server side. To open
recordset on client side you need to do next:
1.If you want to open it using Execute method of
Connection, then set CursorLocation of CONNECTION to
adUseClient. Then open recordset.
2.Or set CursorLocation of RECORDSET to adUseClient and
use OPEN method to open recordset.
Here is an example of cloning of recordset.
Dim loConnection As ADODB.Connection
Dim loSource As ADODB.Recordset
Dim loClone As ADODB.Recordset
Set loConnection = New ADODB.Connection
loConnection.Open "DSN=Test;Database=pubs3;UID=FRI;PWD=", "
FRI", "RAISON"
Set loSource = New ADODB.Recordset
Set loClone = New ADODB.Recordset
loSource.CursorLocation = adUseClient
loSource.Open "select * from authors", loConnection
Set loClone = loSource.Clone
loSource.Close
loClone.Close
Set loSource = Nothing
Set loClone = Nothing
loConnection.Close
Set loConnection = Nothing
Val
Quote:
>-----Original Message-----
>the rs is client-sided !!!!
message
>> > for sure my rs is a valid open recordset. The clone
function doesn't
>work.
>> > What's the problem ???
>> That fact that your rs is server-sided and not client-
sided?
>> Stephen Howe
>.
Clone Recordset