use of ADO and DAO

  • Thread starter Thread starter ReidarT
  • Start date Start date
R

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
 
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)
 
Back
Top