Access 2000 - Queries in code - ADO or DAO

  • Thread starter Thread starter William Roberts
  • Start date Start date
W

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