Cannot be used; the file is already in use solution

Open the web page and prompt "Database connection error", it seems that the program has set a friendly prompt to remove him.

Open the database connection file conn.asp, find on error resume next, comment it out with a single quotation mark, open the error page again, and now it has started to report error: "Can't use ''; the file is already in use in. ”

I found out the problem and solved him.

Error Type: Microsoft JET Database Engine (0x80004005) Cannot use ''; file is already in use.

Error Cause One: Resolved: iis user has insufficient permission to the data directory, ldb file cannot be automatically generated Solution 1: Add internet anonymous user write permission to data directory

Now the directory There is no problem with the permissions, find the next reason

Error Cause 2: The database to be connected has been opened! Close the database to solve the problem! (Maybe someone else is working on your database!) Solution 2: Download the database, select the repair, then upload it, change the name of the database

Successfully solved