ADO or DAO

[Harrild]

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)?

[lenin]

ADO. Smaller / simpler object model, ease of use, etc.

Lenin

[Clunietp]

As a general M$ rule, all new development should be in ADO

[lenin]

* Laughs *

"M$"

[JHausmann]

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...

[Harrild]

ok thanks guys

so is ADO easier to use than DAO?

[JHausmann]

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)...

[Harrild]

thanks guys looks like i should use ADO