H
-Hillary
Can I use ADO or DAO in access 97? THanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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.)
Be sure to use the version 3.5x library, not the 3.6 library (which is
designed of JET 4.)
D
David W. Fenton
Can I use ADO or DAO in access 97?
DAO is what you should use, but ADO *can* be used, just not very
well. A97 does not have the built-in ADO support that A2K and later
had.
It would be a very unusual circumstance where there was a
justification for using ADO in A97.
S
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
ADO is often needed to link to other databases like db2
Regards.
Tom Bizannes
Microsoft Access Development
http://www.smartbiz.com.au
L
Larry Linson
SmartbizAustralia said: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