操作必须使用可更新的查询ASP查询失败 [英] Operation must use an updateable query ASP Query Failing

问题描述

以下是我在运行更新查询后收到的错误代码

Below is the error code I am receiving after running an Update query

2015-02-18 17:30:12 192.168.2.240 GET /webinsert.asp日期= 02/10 / 2015& Field = 38 | 443 | 80004005 | Operation_must_use_an_updateable_query。 80 - Mozilla / 5.0 +（Windows + NT + 6.3; + WOW64; + Trident / 7.0; + rv：11.0）+类似+ Gecko - 500 0 0 56

我最近将数据库从一台服务器移动到另一台服务器。我可以读取数据没问题。它具有适当的IIS用户权限（读取和写入）。任何帮助将不胜感激。

I recently moved the database from one server to another. I can read the data no problem. It has proper IIS User rights (read and write). Any help would be greatly appreciated.

推荐答案

确保您的IIS用户具有.mdb文件的写权限和包含.mdb文件的文件夹（ / wwwroot / db 在您的情况下根据您的评论）。该文件夹需要写入权限，因为Access会在同一文件夹中创建一个.ldb文件来处理数据库锁定。

Make sure your IIS user has write permissions to the .mdb file and the folder containing the .mdb file (/wwwroot/db in your case based on your comment). The folder requires write permission because Access creates an .ldb file in the same folder to handle database locking.

同样来自这里：

你也可以需要在Temp文件夹
上给予读/写权限，因为Jet可能会在此目录中创建临时文件。

You may also need to give read/write permission on the "Temp" folder because Jet may create temporary files in this directory.

我假设他们指的是C：\ Windows \ Temp，但我不是肯定的。

I assume they are referring to C:\Windows\Temp but I'm not positive.

这篇关于操作必须使用可更新的查询ASP查询失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！