Microsoft JET Database Engine error ' 80004005 '

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 '