Access 2000 - Queries in code - ADO or DAO

[William Roberts]

Hello
I am going to start making some of my queries in code. (VB in Access 2000) .
Should I use ADO or DAO? Does it make a big difference and why?

Thanks
William Roberts

 

[Michel Walsh]

Hi,


If you are using a dot-mdb, and interact with forms, DAO would serve you
nicely since they are built (like the RecordsetClone) on DAO, but if you
need some Jet 4.0 extension, you have to use ADO for those parts of your
code.



Hoping it may help,
Vanderghast, Access MVP