Database Purge; Master Database Clear may fail for MS Access databases

The Master Database Clear, found in the Database Purge, may fail for MS Access databases with the following message "Failed to Purge Database. Failed to perform a Master clear. MASTER CLEAR FAILED or PARITALLY FAILED. THIS DATABASE CANNOT BE USED IN A PRODUCTION ENVIRONMENT UNLESS A MASTER CLEAR IS SUCCESSFULLY COMPLETED. Failed to update record in UpdateQueryBuilder. File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.".

This occurs in large Microsoft Access databases because the maximum locking entries has been exceeded.

A change has been made to no longer use Database Transactions within the master database clear for Access databases.

WARNING: If the Master Database clear fails you can try again to see if a second attempt is successful, BUT never use the database in a production environment if it is not completed successfully.