>>Can you give more information on the deferent circumstances that make DAO better than ADO

That was in the context of Access 97, not SQL Server so much. Some benchmarks appear to indicate DAO performs better than ADO.