DAO vs ADO

[Charlene]

I'm modifiying a system written using DAO. Can I just code
my new logic using ADO and leave the old DAO stuff alone
or is it better to convert it all?.

 

[TC]

Depends what you mean by "better". Leaving the DAO alone maens less effort
(good), but also less consistency (bad). Which is more important to you?

If you are mixing DAO & ADO, you'll probably need to qualify each object
with the appropriate prefix; for example:

dim db as DAO.database, rs as DAO.recordset
^^^^^ ^^^^^

This is because DAO and ADO have certain objects in common, but those
objects are not compatible, despite having the same names.

HTH,
TC