>
It's late and I'm in no mood to test this (lol) but why would you expect the <
Recordset data to remain available when you've wiped out the Connection object?
<

Because that is the nature of a disconnected Recordset. You can only do this with Cleint-Side Recordsets...

<
Not having tried this, I don't know if that's expected behavior but it sure doesn't feel right.
<

The kindler, gentler me will let this comment slide...< bg >...