Real Disconnected Recordset

[xor_ax_ax]

I am experienced that Disconected Recordset is not really disconnected. What I expected when using Disconnected
Recordset is really get disconnected from the Server.

I use Data Bound Control like dbGrid tobe bound with this
recordset, and do a little update to the record. I do expect
that this not affected the server but it did.

I think I miss understood the role of Disconnected recordset.
Is there any way to get it work ?

Please Help.

Thanks.

[swatty]

Depends.

How do you fill your recordset, and how are you disconnecting ?

[xor_ax_ax]

Originally posted by swatty
Depends.

How do you fill your recordset, and how are you disconnecting ?

' Connecting, cn is adodb.connection object
set rs.activeconnection = cn
 
' Disconnecting
set rs.activeconnection = nothing

[swatty]

Originally posted by xor_ax_ax

' Connecting, cn is adodb.connection object
set rs.activeconnection = cn
 
' Disconnecting
set rs.activeconnection = nothing

It should work if you're disconnecting like you do.
You cannot reconnect though with this recordset or the changes will be reflected.