Solutions to read-only ASP database objects

Run ASP on Windows + 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"