How to disable Opportunistic Locking or File Caching

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

If you comply with the system requirements for the CS Professional Suite, you should disregard this article. Before disabling opportunistic locking to troubleshoot an issue, we recommend that you first upgrade your workstation and server operating systems to a supported version.

Opportunistic locking is a mechanism for client/server databases to allow multiple processes to lock the same file while allowing for local (client) data caching to improve performance over Windows networks. Unfortunately, the default setting of the opportunistic locking mechanism that enhances the performance of one type of database also introduces data integrity issues for other database types.

Microsoft's documentation states:

"An opportunistic lock (also called an oplock) is a lock placed by a client on a file residing on a server. In most cases, a client requests an opportunistic lock so it can cache data locally, thus reducing network traffic and improving apparent response time. Opportunistic locks are used by network redirectors on clients with remote servers, as well as by client applications on local servers... Opportunistic locks are requests from the client to the server. From the point of view of the client, they are opportunistic. In other words, the server grants such locks whenever other factors make the locks possible."

We have observed numerous instances where opportunistic locking does not release locks correctly, causing performance and data integrity issues. Since disabling opportunistic locking involves editing the registry, contact your qualified IT professional for assistance.

See the links below for more information on how to disable opportunistic locking:

Related topic

Share This