ASP can't update ACCESS database solution

Written in the front:

are all XP troubles. Personally think that XP is excessively pursuing security, but can not be realized as a specific function. Let's take a look at this ASP example, I believe that often contact ASP people will often encounter this problem: obviously their code is written correctly, why can't it be updated normally? The following error messages are not caused by the code error of ASP itself, but some permission settings. Start When I encountered this problem, I used to self-study to check my code no less than 10 times, that is, I did not check out the ASP error. Finally, I checked the Internet and found that it was a wicked permission.

Operating environment: windows xp

IIS 5.0

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

Running the asp program on a Windows XP+IIS server may The database cannot 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 updateable query.

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

There are several solutions (there may be different solutions for different servers, assuming the website home directory is wwwroot):

A, 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 best way to solve this problem at present, generally can solve the problem

XP system may right click to not see the "Security" option, please open "Tools" - "Folder Options" - "View" - Cancel "Use Simple File Sharing (Recommended)" and then you can find it in the properties "Security" option

C, right click on the wwwroot folder - "Properties" - "web sharing" - "shared folder"

D. More solutions please and me Discuss together~QQ:7021357

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

Last One thing is, if you want to set your own machine to debug ASP server, then it is best not to use win XP system, choose WIN 2000 is appropriate, it is not good... then be prepared to take a lot of detours!... .

Of course, when XP has some inexplicable problems, please consider the XP permissions settings.