ну и я свой отрывок дам :)
Optimizing for Client/Server Performance (2.0, 95,97 Access)
(ms-help://MS.MSDNQTR.2003APR.1033/enu_kbaccesskb/accesskb/128808.htm)
1.
2.
3.
4.
5.
6.
7.
Transactions
Using transactions when you update or insert records on attached tables in Access Basic can improve
performance. Transactions enable the Jet database engine to accumulate multiple updates and write them as a
single batch. With Microsoft SQL Server, keep transactions short because they generate locks that prevent
other users from reading data affected by the current transaction. Although you can nest transactions using
Visual Basic, most servers do not support nested transactions. Microsoft Access sends only the first-level
transaction to the server.
для акес 2000 (ms-help://MS.MSDNQTR.2003APR.1033/enu_kbacc2000kb/acc2000kb/208858.htm)
1.
2.
3.
4.
5.
6.
7.
Transactions
Using transactions in Visual Basic for Applications (VBA) when you update or insert records on linked tables
can improve performance. Transactions enable the Jet database engine to accumulate multiple updates and write
them as a single batch. With Microsoft SQL Server, keep transactions short because they generate locks that
prevent other users from reading data affected by the current transaction. Although you can nest transactions
with VBA, most servers do not support nested transactions. Microsoft Access sends only the first-level
transaction to the server.
А вот почему ЛП меня одернул :) (ms-help://MS.MSDNQTR.2003APR.1033/bapp2000/html/acbachap06.htm)
1.
2.
3.
4.
5.
6.
7.
8.
9.
Transactions and Performance
In previous versions of Access, it was generally recommended that you use transactions as a performance
enhancement. Now all transactions for DAO add, update, and delete operations are performed internally and
automatically. In most situations, this automatic support provides your application with the best possible
performance. However, there may be situations where you want to fine-tune transaction behavior. You can do
this by creating and modifying various settings in the Microsoft® Windows® Registry.
See Also For information about tuning Registry settings used by Microsoft Jet, see "Adjusting Windows
Registry Settings to Improve Performance" in Chapter 7 , "Optimizing Your Application."
