queryDef in access 2000

[ChasW]

I just tried the 2nd example at this url and it starts out as:
Dim Q As QueryDef

http://support.microsoft.com/default.aspx?scid=kb;en-us;135546

...but i get user-defined type not defined. is this type present in
access 2000?

FYI, I am patched to sp-3 and the latest Jet.

Chas

 

[MGFoster]

I just tried the 2nd example at this url and it starts out as:
Dim Q As QueryDef

http://support.microsoft.com/default.aspx?scid=kb;en-us;135546

..but i get user-defined type not defined. is this type present in
access 2000?

FYI, I am patched to sp-3 and the latest Jet.

In a VBA module, on the menu bar, select Tools > References. In the
list box check the Microsoft DAO 3.6 Object Library. Then click OK.

In Access 2000 the new data access class is ADO.