Opportunistic securing or Oplocks is really a Home windows mechanism created for client/server databases that enables several ways to lock exactly the same file, when on a single time local data caching enhances the performance over network. However these default configurations from the mechanism, which enhances the performance of one sort of client/server databases, can negatively affect database integrity of different kind. This database corruption can also be noticed in Access databases. The chances of Access database getting corrupted increase if opportunistic securing is enabled. To correct the corrupted Access database, run ‘Compact and Repair utility. But when the tool does not perform its task, restore it from backup or use software to correct the database.
As one example of this, consider that you employ a credit card applicatoin, which accesses an Microsoft Access database. This application operates on different client computer systems along with a Home windows File Server stores the databases. After a while, you find that Access database is corrupt and reviews errors.
The above mentioned Access database corruption problem could occur if ‘opportunistic locking’ is enabled. Once the database file is utilized and shared among multiple clients on the network file server that supports opportunistic securing, it could get corrupt. Exactly the same problem is applicable to clients running Home windows XP or 2000 and linked to personal files server supporting the feature.
Following would be the tips to solve the given problem:
When the file server is applying Home windows 200, install Home windows 2000 SP3 or afterwards the server as well as on each one of the clients attached to the server For Home windows XP computer systems, install the related security update When the corruption is persistent after setting up the updates, disable opportunistic securing Attempt to repair the broken database using built-in Compact and Repair utility If you can’t repair the database while using tool, restore the database from backup You may also use third-party Access Database Repair software to restore and repair broken Access database. Access Repair utilities are high-finish tools using effective checking calculations to correct Access files. Due to their interactive interface, these power tools require no prior technical understanding.
Stellar Phoenix Access Recovery is finished repair solution for broken Access databases. It repairs files produced with Microsoft Access 2007, 2003, 2002 and 2000. It’s a safe utility that reinstates all database objects including queries, reviews, forms, macros and modules. The tool works with Home windows Vista, XP, 2003, 2000 and NT.