ado or dao

[-Hillary]

Can I use ADO or DAO in access 97? THanks.

 

[Allen Browne]

A97 knows all about DAO.

Be sure to use the version 3.5x library, not the 3.6 library (which is
designed of JET 4.)

 

[SmartbizAustralia]

DAO is simpler, quicker and easier to code.

ADO is often needed to link to other databases like db2

Regards.
Tom Bizannes
Microsoft Access Development
http://www.smartbiz.com.au

 

[Larry Linson]

DAO is simpler, quicker and easier to code.

I agree.

ADO is often needed to link to other databases like db2

Really? I thought there were ODBC drivers for "databases like db2" that
worked very nicely. I've been linking to tables in server databases with
ODBC drivers since back in the days of Access 2.0, and found that most (and
I believe that includes DB2) are ODBC-compliant.

I'd guess, considering databases still in use, but not updated in recent
years that the universe of ODBC-compliant databases would be greater than
the universe of OLEdb-compliant databases.

Larry Linson
Microsoft Access MVP