ADO in Access 97?

[thad]

Hi All,

I just had a quick question. Can you use ADO in Access
97? Do you have to reference a particular Active X Object
in Access 97 to use it?

 

[Eddy]

If I remember correctly, there is ADO available in Access 97. Do not ask me
what the version is. It should be ADO 2.x. Yes Go to Tools, Reference, and
select the version of ADO you need to reference to. If you don't use DAO
anymore, deselect the DAO referece.

 

[Paul Overway]

You can use ADO in Access 97. However, DAO is a required reference.

 

[Douglas J. Steele]

ADO did not come with Access 97: I don't believe it had been developed when
Office 97 was released. However, if MDAC has been installed on the machine,
then there will be a reference available, and you can use ADO.

Like Paul says, though, I believe you must keep the reference to DAO. That
means that since there are objects with the same name between the two
models, you'll need to disambiguate certain declarations. For example, to
ensure an ADO recordset, you'll need to use Dim rsCurr as ADODB.Recordset
While not strictly necessary due to the order the references appear (but not
a bad habit to get into), you'd use Dim rsCurr As DAO.Recordset to guarantee
a DAO 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