I am still using DAO syntax on an old large (100,000 lines of Basic, 160+
tables) Access project. I was thinking about starting to use ADO instead
and have a few questions:
1) If one uses ADO rather than DAO will there be fewer ODBC drivers that
the resulting application will work with?
IOW, does ADO use more advanced features of ODBC than does DAO?
2) Is ADO-based code any faster than DAO-based code?
3) Are there any other possible pitfalls of doing a partial migration to