Problem overwriting MS Access Database

When a Microsoft Access database is in use, the server locks it to prevent the file from being deleted or modified.

A script that is working correctly will lock and unlock a database in less than a second. If, however, your scripts are not closing the database connection after a database query, the database will remain locked. There is a 5 minute timeout set on the server, which will eventually release the database connection, and allow you to overwrite the file, but if you have more that a few users per hour on your website, your database will likely always be in use. You will need to review your scripts and make sure that there is always a close connection string after every open connection string.

<< Back