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
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
"Eddy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>
> "thad" <(E-Mail Removed)> ?????
> news:046c01c37970$48eb63f0$(E-Mail Removed)...
> > 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?
>
>
Similar Threads
