Microsoft JET Database Engine error ' 80004005 '

Source: Internet
Author: User
Tags microsoft access database

Microsoft JET Database Engine error ' 80004005 'The Guest account does not read or write to the ASP storage directory

Cause of failure

This type of error generally occurs in the file system in NTFS format, which is the IIS anonymous account (IUSR_ computer name) due to insufficient permissions to the related files and folders.

One, the database folder to the IIS anonymous account does not write, modify permissions, the error shows that the database can not be updated, write

Second, the System temporary folder directory to IIS anonymous account does not write, modify permissions, the error is that the access server on any of the Microsoft JET link Access class database files are error. This error does not normally occur when using some system garbage cleanup optimizer, or some other factor may cause this directory permission to change. So use this kind of tool with caution.

Solutions

One, check if the folder that holds the Microsoft Access database files has write access to the IIS anonymous account, and if not, assign write permissions, especially if the error message is (Microsoft JET error ' 80004005 ' The operation must use an updatable query. When

How to give IIS Anonymous account Write permissions:

1. Right-click the folder that holds the database, view properties--Find the Security tab--There are permissions for groups and users, and you can view the appropriate permissions for the IIS anonymous account and modify it.

Properties, Sites



2. If the Security tab is not found in the attribute, open My Computer--tools--Folder Options--View--to remove the tick before "Use Simple file Sharing (recommended)"--OK. Then you can re-modify the database folder.

Right-click the Site folder properties, the "Security tab" appears, click "Add"



The jet engine creates temporary files in the%windir%/temp/directory when the database is linked, and the IIS anonymous account does not have enough permissions on the%windir%/temp/directory to add the IIS Anonymous account (IUSR_ computer name) to%windir%/temp/ Read and Write permissions.

For some other unspecified errors, you can try to re-register the ASP script to interpret the link library file.

Run the following commands sequentially:

1.regsvr32 Jscript.dll

2.regsvr32 Vbscript.dll

3.iisreset

Microsoft JET Database Engine error ' 80004005 '

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.