Microsoft JET Database Engine error ' 80004005 ' ERROR

Source: Internet
Author: User
Tags anonymous file system microsoft access database

A batch cleaned up the computer garbage, resulting in an error with the ACC database.

System environment

Windows 2003+iis6+ntfs

Asp+access

Error message

Microsoft jetdatabase Engine error ' 80004005 ' Unspecified error

Cause of failure

This type of error typically occurs in the file system as NTFS, and is the result of an insufficient number of IIS anonymous accounts (IUSR_ computer names) that are associated with inadequate file and folder operation permissions.

First, the Storage database folder for IIS Anonymous account does not write, modify permissions, the error is not to update the database, write

Second, the system Temp folder directory has no write to IIS anonymous account, modify permissions, error performance is the access on the server any Microsoft JET database Engine linked access class databases of the file is an error. This error does not normally occur when using some system garbage cleanup optimization tools, or some other factor may cause the directory permissions to change. So use this kind of tool with caution.

Solutions

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

The JET engine creates temporary files in the%windir%/temp/directory when linking to the database, and IIS anonymous accounts do not have sufficient permissions to%windir%/temp/directory operations, adding IIS anonymous accounts (IUSR_ computer name) to%windir%/temp/ Read and Write permissions.

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

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.