ADO and DAO in same database

[Abroit]

I know that ADO is a newer technology than DAO.

Can a database application use both.

Specifically, can some forms in a database use DAO and some use ADO?

Can one command button on a form use DAO and another button on the same form
use ADO?

 

[Dave Patrick]

Yes, it is possible. This link may help.

http://allenbrowne.com/ser-38.html

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I know that ADO is a newer technology than DAO.
|
| Can a database application use both.
|
| Specifically, can some forms in a database use DAO and some use ADO?
|
| Can one command button on a form use DAO and another button on the same
form
| use ADO?
|
|

 

[Douglas J. Steele]

As Dave indicated, there's no problem. The "secret" if you have both
references is that you 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