This is what I found out too.

DB_OPEN_DYNASET is quite a lot faster, than Snapshot.

The only reason why I thought to change to ADO in MS-Access is because it would be a lot easier to make the application compatible both with MS-Access ans SQL server. For SQL Server DAO does not work at all, as far as I found out.

This was the reason why I started to investigate in ADo with Access. But the performance is so poor, we cannot do this.

Strange enough: Microsoft says, ADO is the model to be used in the future, also it should have a better performance than DAO (see http://www.microsoft.com/msj/0299/ado20/ado20.aspx)

I don't know, what I should believe