How to disable Opportunistic Locking or File Caching

Alerts and notices

Important reminder!

Product support for Engagement CS is ending on September 30, 2020. See Engagement CS license expiration 2020 - frequently asked questions for more information.

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS permanently expired on March 1, 2017.

Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of Creative Solutions Accounting.

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