I am attempting to creat a frontend for a cd database i have in access97 and i was wondering wich would be better to use? ADO or DAO (there are two kinds of tables; the main tables and the individual cd tables which are all the same format)?
Printable View
I am attempting to creat a frontend for a cd database i have in access97 and i was wondering wich would be better to use? ADO or DAO (there are two kinds of tables; the main tables and the individual cd tables which are all the same format)?
ADO. Smaller / simpler object model, ease of use, etc.
Lenin
As a general M$ rule, all new development should be in ADO
* Laughs *
"M$"
You may need to do both (for example, if you include a compact/repair function).
However, Microsoft has decreed that ADO is the wave of the future. And, usually, whatever Microsoft wants...
ok thanks guys
so is ADO easier to use than DAO?
Yes. Depending on your data sources and the type of access you're accustomed to, it can range from very little difference (DAO and Jet) or a whole lot (if you were using SQL Server and ODBC previousy).
Bad news is it's still a work in progress (the bulk of what you want to do probably exists)...
thanks guys looks like i should use ADO