I am very new to this whole ADO thing as well as to DB programming in general. One thing I'm confused about is the whole concept of a recordset. I thought a recordset was a like a returned array (for lack of a better analogy), which is basically a representation of a table.

But one thing I'm trying to do tells me otherwise. I'm trying to write a function that returns a static recordset and then closes the recordset and closes the database connection. However that isn't possible, because once those things are closed the recordset that I returned is closed. So it looks like i can't pass back a static version of a recordset. Fine. Is this true, or is there a way to return a static recordset and close the original.

Second. Another thing I tried was to close the database connection and then return the recordset. When I did that, the recordset was still there oddly enough. It's like unpluggin the TV and leaving the cable in and the TV still works. Can somebody explain this weird paradigm to me? Thank you.