Real Disconnected Recordset

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.

Depends.

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

Quote:

---

Originally posted by swatty
Depends.

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

---

VB Code:

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

Quote:

---

Originally posted by xor_ax_ax

VB Code:

' 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.