ASP cannot update Access database workaround

access| Solution | data | database

Written in front:

It's all because of XP. Personally think that XP excessive pursuit of security, and the specific functions can not be compensated for. Here's a look at this ASP example, I believe that people often contact with the ASP will often encounter this problem: clearly their own code written very correctly, why is not normal update it? The following error messages are not caused by the Code errors of the ASP itself, but by the setup of some permissions. At first I encountered this problem, once self-study check their own code no less than 10 times, is not checked out the error of the ASP. Finally, the Internet check to find out that is the evil of the right to trouble

Running environment: Windows XP

IIS 5.0

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

Running an ASP program on a Windows Xp+iis server may cause the database to be unable to update, and the specific error message might be:

1. Microsoft JET Database Engine (0X80040E09) cannot be updated. 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.

The solutions are as follows (for different servers may be resolved differently, where the site's home directory is assumed to be wwwroot):

A, right-click on the Wwwroot folder-"Properties"-Cancel "read Only"

This method is the simplest and occasionally effective

B, on your database file folder above right-click-"Properties"-"security"-Add Users: "IUSR_ computer name" and open "IUSR_ computer name" read, Write permissions

This method is the best way to solve the problem at present, it can solve the problem generally

XP system may right-click to see the "Security" option, please open the "Tools"-"Folder Options"-"View"-Cancel "use Simple File Sharing (recommended)" and then find the "security" option in the properties

C, right-click on the Wwwroot folder-"Properties"-"Web Share"-"Shared Folders"

D. More solutions Please join me in the discussion. ~qq:7021357

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

The last point is that if you want to set up their own machine to debug the ASP server, then it is best not to use the Win XP system, choose Win 2000 is advisable, really not ... So get ready for a lot of detours!....

Of course, in the case of XP inexplicable problems, please think more about the permissions of XP issues