datatype querydef is not available

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get a compile error "user defined type not defined" when
i want to run this procedure.

Sub test2()
Dim qryd As querydef
End Sub

In the help files there is also no information available
on querydef.

Is this a extra feature that needs to be installed
separately

I am using
Visual basic 6.0.8435 forms3: 2.01
and Access 9.0.2720
 
QueryDef is a DAO object. By default, Access 2000 uses ADO.

With any code module open, select Tools | References from the menu bar,
scroll through the list of available references until you find the one for
Microsoft DAO 3.6 Object Library, and select it. If you're not going to be
using ADO, uncheck the reference to Microsoft ActiveX Data Objects 2.1
Library

If you have both references, you'll find that you'll need to "disambiguate"
certain declarations, because objects with the same names exist in the 2
models. For example, to ensure that you get a DAO recordset, you'll need to
use Dim rsCurr as DAO.Recordset (to guarantee an ADO recordset, you'd use
Dim rsCurr As ADODB.Recordset)

The list of objects with the same names in the 2 models is Connection,
Error, Errors, Field, Fields, Parameter, Parameters, Property, Properties
and Recordset
 
Back
Top