[AccessD] DAO vs ADO

I'm confused when looking at these two libraries.  My questions are
many, so I listed only a few below.
1.  What is the difference?  Yeah I know, this is a loaded question, but
how do I know when looking at code it's either one?
Can they be mixed?

2.  Which is recommended for MDBs - or is there no difference in
performance?

3.  I read somewhere, that ADO is required for ODBC to SQL Server with
an Access FE - is that correct?

That's enough for now, Thanks!

Jim
 
Jim H. Hewson
Applications Support Manager
Karta Technologies, Inc.
5555 Northwest Parkway
San Antonio, Texas 78249
210-582-3233 
jhewson at karta.com