ASP, Access, Permissions, and an Exicting Sudden Error 1

[Genimuse]

I've got an intranet running for a client, simple enough little thing running on Win2k Server and MS Access 2000.

Database access is light, and has worked like a champ for many months.

Suddenly I have a problem: After a small number of writes to the database -- it can read forever, after 1 or 2 inserts, updates, or deletes -- I receive a good ole 80004005 error, specifically:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file 'MyPathAndFileNameIsHere.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Searches here and on Google indicate that it's a permissions problem, but (a) the permissions hadn't changed, and (b) I gave Everyone and IUSR and IWAM total control over the entire drive (and yes, made sure that included the directory the db is in, the db, and temp folders), but the problem remains.

The database isn't open any other way (like in InterDev or in Access or anything).

My connection is directly to the file, it doesn't use a DSN (as you can probably tell from the error).

I updated to Jet 4.0. I updated to MDAC 2.7. I've tweaked every little thing I can possibly think of. Help! The only way to recover is to restart the server. Which, unsurprisingly, isn't a very satisfactory solution.

Any ideas on what I could be missing, what I might not have thought to look for?

Oh, also, I haven't had any Windows Updates run in 2 weeks, and the problem is only a few days old, so no changes there, either.

Thanks in advance.

 

[Sheco]

I think you should have a star for sharing this solution with us. Someone out there will have this exact problem sometime in the future and hopefully they will find your solution.

 

[Genimuse]

LOL, thanks. I do hope that someone else finds it useful. It was probably a matter of my search-fu, but I could find no reference to it via search engines or searching here.