Shulou(Shulou.com)06/02 Report--

How to solve the problem that ASP can not update the ACCESS database? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Let's take a look at this ASP example. I believe that people who are often in contact with ASP will often encounter this problem: why can't they update normally when their code is written very correctly? The following error messages are not caused by code errors in ASP itself, but are caused by some permission setting problems. At first, when I encountered this problem, I used to self-study to check my code no less than 10 times, but I didn't check out the ASP error. After looking it up on the Internet, I found that it was caused by the evil authority.

Operating environment: windows xp

IIS 5.0

Running the asp program on the Windows XP+IIS server may cause the database not to be updated, and the specific error message may be:

1. Microsoft JET Database Engine (0x80040E09) cannot be updated. The database or object is read-only

2. Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft] [ODBC Microsoft Access Driver] operation must use an updatable query.

3. The Microsoft JET Database Engine (0x80004005) operation must use an updatable query.

There are the following solutions (different servers may have different solutions. Here, assume that the home directory of the website is wwwroot):

Right-click on the wwwroot folder-"Properties"-cancel "read-only"

This method is the simplest and occasionally effective.

B. Right-click on the folder on your database file-"Properties"-"Security"-add user: "IUSR_ computer name" and open the read and write permissions of "IUSR_ computer name"

This method is the current way to solve this problem, and it can generally solve the problem.

You may not see the "Security" option by right-clicking on the XP system. Please open "tools"-"folder options"-"View"-cancel "use simple File sharing (recommended)" and then you can find the "Security" option in the properties.

C. Right-click on the wwwroot folder-"Properties"-"web sharing"-"shared folder"

Finally, if you want to set up your machine as a server for debugging ASP, it is best not to use win XP system, but to choose WIN 2000. Then be prepared to take a lot of detours.

Of course, when there is an inexplicable problem with XP, please consider the permission setting of XP.

This is the answer to the question about how to solve the problem that ASP can not update the ACCESS database. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.