use of ADO and DAO

[ReidarT]

I use both ADO and DAO in an application. I prefere ADO, but I find it
difficult to find commands to add new fields in a table in a back-end
database and to compress the backend-database without using DAO.
My question is: When using both ADO and DAO, does it influence on the speed
of the database like listing records, lookup and so on.
best regards
reidarT

 

[Douglas J. Steele]

Assuming you're just connecting to a Jet database (i.e. an MDB), DAO is
faster. This is because DAO was specifically designed for Jet databases,
whereas ADO is a generic approach, and hence introduces additional layers of
abstraction.

FWIW, though, check http://support.microsoft.com/?id=230501 for how to
compact using ADO, and you can use ADOX to make changes to the table design
(or ALTER TABLE SQL statements)