Solution to Asp Access update failure

Running asp programs on windows + iis servers may cause database update failures. 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.

Solution (assume that the home directory of the website is wwwroot ):

In the wwwroot folder, right-click "properties"-"security"-Add User: "IUSR _ computer name" and enable the read and write permissions for "IUSR _ computer name ".

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.

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: Why can't I update my code properly? 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.

IIS 5.0 copyright: All articles on this site are from the Internet.

--------------------------------------------------------------------.

Running asp programs on Windows xp iis server may cause the database to fail to be updated. The specific error message may be: copyright statement: All articles on this site are from the network, all comments reposted on this site do not represent the point of view on this site

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. If you need to use the photos, illustrations, and design works provided by this site, contact the original author.

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

The solution is as follows (the solution may be different for different servers. Here we assume that the home directory of the website is wwwroot ):.

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

This method is the simplest and occasionally effective according to Experts' observations. Such theories and phenomena are worthy of consideration by webmasters. Therefore, we hope you can do more research and study and strive to sum up more and better experiences!

B. Right-click your database file folder and choose "properties"> "security"> "Add User: "IUSR _ computer name" and open "IUSR _ computer name" read and write permissions.

This method is currently the best way to solve this problem, and can generally 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) "Then you can find the" Security "option in the property copyright statement: This site's articles are from the network, and all the reposted articles on this site do not represent the site's views

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

D. For more solutions, please discuss them with me ~ QQ: 7021357.

The last point is that if you want to set your machine as a server for debugging ASP, it is best not to use Windows XP system. win 2000 is the best choice, but it is not feasible... so be prepared to take a lot of detours !.... Note: All comments reposted on this site do not represent the point of view on this site. If you need to use the photos, illustrations, and design works provided on this site, please contact the original author.

Of course, when XP encounters an inexplicable problem, consider XP permission settings.