ASP access can not update the solution _ Application Tips

Source: Internet
Author: User
Tags odbc ole
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.

Workaround (Here assume the site's home directory is wwwroot):

Right-click on the Wwwroot folder-"Properties"-"security"-Add Users: "IUSR_ computer name" and open read, write access to "IUSR_ computer name"

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

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 Copyright Disclaimer: This site is from the network of articles.

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

Running an ASP program on a Windows XP IIS server may cause the database to be unable to update, and the specific error message may be: Copyright Disclaimer: This site is from the network, all the articles reproduced in this site does not represent the views of the site

1. Microsoft JET Database Engine (0X80040E09) cannot be updated. The 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. This site provides photographic photos, illustrations, design works, if necessary, please contact the original author.

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

There are several solutions (for different server possible solutions, where the site's home directory is wwwroot):.

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

This method is the simplest, occasionally effective according to expert observation, such a theory and phenomenon are worthy of all the webmaster thoughtful, so I hope that we do more research and learning, and strive to summarize more and better experience!

B, right-click on the folder on your database file-"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 click the right button to see the "Security" option, please open the Tools-Folder Options-View-Cancel use Simple file sharing (recommended) and then locate the security option in the property. Copyright: This site articles are from the network, this site all reproduced article comments do not represent the views of the site

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

D. More solutions Please join me in discussing the ~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!.... Special Note: This site all reproduced articles do not represent the views of the site, the site provides photographic photos, illustrations, design works, if necessary, please contact the original author.

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.