• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Transaction Processing > Modifying the Default Behavior

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 97. Three Registry settings affect implicit transactions in Access 97: ImplicitCommitSync, ExclusiveAsnycDelay, and SharedAsyncDelay. These keys are located in the \HKEY_LOCAL_MACHINES\SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 3.5 Registry folder.

The ImplicitCommitSync setting determines whether the system waits for a commit to finish before proceeding with application processing. The default is No. This means that the system will proceed without waiting for the commit to finish. You generally won't want to change this setting; using No dramatically improves performance. The danger of accepting the value of No is that you will increase the amount of time during which the data is vulnerable. Before the data is flushed to disk, the user might turn off the machine, compromising the integrity of the data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint