Microsoft KB Archive/153491

= PRB: Jet 3.0 UserCommitSync & ImplicitCommitSync Values Wrong =

Article ID: 153491

Article Last Modified on 6/23/2005

-

APPLIES TO


 * Microsoft Visual C++ 4.0 Standard Edition
 * Microsoft Visual C++ 4.1 Subscription
 * Microsoft Visual C++ 4.2 Enterprise Edition
 * Microsoft Visual C++ 4.2 Professional Edition

-



This article was previously published under Q153491



SYMPTOMS
If you explicitly specify values for the Jet 3.0 UserCommitSync or ImplicitCommitSync keys in the registry, these values will not have the expected effect.



CAUSE
According to the Microsoft Jet Database Engine Programmer's Guide, the UserCommitSync and ImplicitCommitSync keys can have the following values:

"Yes signifies that Microsoft Jet will wait for commits to finish. Any other value means that Microsoft Jet will perform commits asynchronously."

Jet 3.0 incorrectly interprets the value "yes" as asynchronous and "no" as synchronous for these two keys.



RESOLUTION
Specify "yes" for asynchronous and "no" for synchronous.



STATUS
We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
These string values can be explicitly set in the registry under: HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.0\Engines\Jet

