ADO and DAO reference problems

[antonio.santibanez]

I have a Form with ADO code and a Report with DAO code. They cant work together.
How do i work around this feature.
The DAO code is huge, and i really dont want to rewrite it to ADO.

Please Help

 

[Peter D]

Include references to both DAO, and ADO. Then in your DIM statements, specify which common objects (recordsets, fields, etc) belong to DAO like so: DAO.recordset, and which belong to ADO like so: ADODB.recordset.

Ex.:

Dim rst as DAO.recordset
dim rst2 as ADODB.recordset

Hope this helps,

Peter De Baets
Peter's Software - Ms Access Tools for Developers http://www.peterssoftware.com

 

[antonio.santibanez]

Yeah..it really works..thanks...:0)))))