openrecordset method for queries

I'm very much a novice with VBA, but used it previously
to automate some work in Access 2000. At the time,
I used the following type of statement to query data in my
database and return it as a recordset that I then used in
a module:

Dim Precip as recordset
Set Precip = dbs.Openrecordset("SELECT * FROM table1;")

I'm now trying to write a new module and using an updated
version of Access (2002) and the same statement returns
the following error "run time error 13 - type mismatch"

I'm wondering if something changed in this respect after Access
was updated, and if so, how to write a statement with
Access 2002?

Thanks very much,
David

Please disregard this question...

I got this to work once I added the same reference libraries
to the module in Access 2002 that were used with my
module in Access 2000....

(Microsoft DAO 3.6 Object Library, OLE Automation,
Microsoft Visual Basic for Applications Extensibility 5.3)