After reading so many different things about the speed of ADO vs DAO I decided to do my own performance tests.

Conclusion : If accessing an Access database then DAO is faster than ADO. Yes thats right. If you only have a small number of records then the speed difference won't be noticed, but with large numbers the difference can be quite noticeable.

If the DB you want to design has the possibility of growing very large, and being upgraded to SQL Server, then you are better off using ADO as the transition between the two will be easier.