Simple question can I use ADO in Access 97. If so can I easily move over from DAO to ADO and what are main benefits of converting an application from DAO to ADO.
I can't be 100% certain, but I think you can use ADO in access97, you just have to install, and reference the ado library...
As for advantages...
Well, DAO is native to access, however ADO is more general, and used to connect to external applications.
So if you are connecting to an external database or any other data source or document, then use ADO to get the data, however it'd be simpler and quicker to use DAO when you're just manipulating data within your database...
I have used ADO in Access 97. You need to check the ADO library to make it available in your app. The library will say something like ActiveX ADO 2.6 or something similiar.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.