DAO vs ADO

  • Thread starter Thread starter Charlene
  • Start date Start date
C

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?.
 
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
 
Back
Top