Modifying the Default Behavior
Before you learn how to implement transaction processing, take a look at what you can do to modify the default behavior of the transaction processing built into Access 2002. Three Registry settings affect implicit transactions in Access 2002: ImplicitCommitSync, ExclusiveAsnycDelay, and SharedAsyncDelay. These keys are located in the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0 Registry folder.
TIP
You can access the Windows Registry using the RegEdit utility. To utilize RegEdit, select the Run option from the Start menu. Then type RegEdit.
The ImplicitCommitSync setting determines whether the system waits for a commit to finish before proceeding with application processing. The default is No
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
