VB Forum / Database Access / August 2005

Thanks for your prompt reply, Brijesh

I'm not quite following your example. Basically what I want to do is to
reteieve a subset of records from an existing Recordset object. For example,
let's say I had a database containing info about books that resided on a
server somewhere. One day I retrieve a Recordset containing all the fields
of all the records from the Books table. Then, and this is one of the main
points, I save that recordset to the hard drive of my laptop as
MyRecset.adtg.

Now imagine that I am working somewhere without internet connectivity (thus
unable to connect to the original database on our server) and I want to
generate a subset of the records contained in MyRecset.adtg. For instance, I
might want to get a Recordset containing all records in which the
publication date was before a certain date.Thus I can do something like
this:

Dim oRecsetMain as Recordset
Const sLocalPath as String = "C:\MyDir\MyRecset.adtg"

oRecsetMain.Open sLocalPath

So now I have a Recordset containing all of the records from the main
database. But what I want is a Recordset that would be the same as that
which might have resulted from a query to the main database with something
like "SELECT * FROM Books WHERE PubDate < 10/31/1995".

How can I get a Recordset out of oRecsetMain that contains only those
records?

Thanks
WIlliam

Thanks Adrian
I will have a look at that. Since my last post I've been playing around with
using the Recordset.Filter property. I may be able to get what I need with
that.
WIlliam