ASP_80004005|Operation_must_use_an_updateable_query

Error:

2004-04-27 00:36:14 195.68.81.10 - 195.68.81.10 8123 POST /ResolveSpam.asp |86|80004005|Operation_must_use_an_updateable_query. 500 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0)

Solution:

add the privilege of ASPNET and IUSR_ to the db folder that your dbfile locate in

Those errors look like they're caused by your ASP pages not being able to update the Access .mdb database. Please note that IIS normally uses the IUSR account to access resources on the web server. That accout will need write access to the directory the Access database resides in. So if you're using NTFS you'll need to grant RWD (read write delete) permissions to the database directory. It's not enough to give the RWD rights to the mdb file itself because MDAC creates a .lck file as well when updating the database in the same directory.

If you are worried about security (you probably are since it looks like you tightened down security on the server - by default Microsoft allows Everyone FULL control, very frightening...) please note that this is the reason we recommend using UDL files. If you place the mdb file in a directory outside the web area and/or outside any virtual directories, the IUSR will not be able to access that directory. But your ASP code is using an UDL file for the connection, which will tell MDAC about the physical location of the file, and being outside the web are will not pose an obstacle. MDAC will be able to read the mdb file, but the IUSR will not.