QueryDef and DAO reference????

[sjh]

Hi,
I am using QueryDef to call existing queries in my database. In my references, the following is checked.
Microsoft DAO 2.5/3.51 Compatibility Library

Is this necessary to use the QueryDef? I tried to select DAO 3.5 and 3.6 obejct library, but it gives me a type mismatch error.

How can I fix this problem???


Thanks!
sjh

 

[Rick39]

Try:

Dim MyDb as Database
Dim MySet as Recordset

Set MyDb = CurrentDB
Set MySet = MyDb.Openrecordset("YourQueryName", DB_OPEN_DYNASET)

 

[JamieDeVry]

The problem is with your declaration. Microsoft Access support ADO and DAO. You now must specifiy the recordset you want to work with.

Dim MyDb as DAO.Database
Dim MySet as DAO.Recordset

Set MyDb = CurrentDB
Set MySet = MyDb.Openrecordset("YourQueryName", DB_OPEN_DYNASET)


God Bless!

Jamie

http://nj.devry.edu/~jbates