-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|