ASP cannot update Access Database Solution

Preface:

It is a fault caused by XP. I personally think that XP pursues excessive security, and the specific functions cannot be implemented as compensation. let's take a look at this ASP example. I believe that people who often come into contact with ASP will often encounter this problem: clearly understand their ownCodeThe write is correct. Why cannot I update it normally? The following error messages are not caused by ASP code errors, but by permission settings. when I first encountered this problem, I used to check my code for less than 10 times, that is, I did not check ASP errors. finally, I checked the Internet and found that it was an evil permission.

Running Environment: Windows XP

In IIS 5.0

--------------------------------------------------------------------

Run ASP on Windows XP + IIS serverProgramThe database may fail to be updated. The specific error message may be:

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

2. The Microsoft ole db provider for ODBC drivers (0x80004005) [Microsoft] [ODBC Microsoft Access driver] operation must use an updatable query.

3. Microsoft Jet Database Engine (0x80004005) must use an updatable query.

There are several solutions as follows (different solutions may be provided for different servers. Here we assume that the home directory of the website is wwwroot ):

A. Right-click the wwwroot folder and choose "properties"> "read-only"

This method is the simplest and occasionally effective

B. Right-click your database file folder and choose "properties"> "security"> "Add User: "IUSR _ computer name" and "IUSR _ computer name" Read and Write Permissions

This method is currently the best solution to this problem. Generally, it can solve the problem.

You may not be able to view the "Security" option by right-clicking on the XP system. Open "Tools"> "Folder Options"> "View"> cancel "use simple file sharing" (recommended) "And then you can find the" Security "option in the property.

C. Right-click the wwwroot folder and choose "properties"> "Web Sharing"> "shared folder"