quartz wrote:

Is it possible to now query the disconnected recordset?

Not really. There may be other ways to achieve the same results. I use
the recordset Filter method a lot. You can create a JOIN between ODBC
sources using the Jet OLE DB providers or MS Access/Excel ODBC drivers
e.g. to create a JOIN between a text file and a SQL Server table.
Something else to consider is data shaping e.g. to create a
hierarchical recordset (i.e. a recordset of recordsets), append a new
writable column to the recordset, etc. For some articles on SHAPE, see:

http://msdn.microsoft.com/library/de...atashaping.asp
Jamie.

--