To resolve ASP database objects as read-only methods

Object | solution | data | database

Running an ASP program on a WINDOWS+IIS server may cause the database to be unable to update, and the specific error message may 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"