Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can i use ADO in Access 97

Status
Not open for further replies.

simeybt

Programmer
Nov 3, 2003
147
GB
All,

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.

Simon
 
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...

hope that's clear
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top