Microsoft Jet Database Engine error '000000' error solution [arrangement]

This article is organized by the maintainer Ms

System Environment
Windows 2003 + IIS6 + NTFS
ASP + Access

Error Message
Microsoft jetdatabase engine error '123' unspecified error

Fault Cause
This type of error occurs generally when the file system is in NTFS format and is an IIS Anonymous Account (Iusr_computer name.
1. the folder for storing the database does not have the permission to write or modify the IIS Anonymous Account. The error is that the database cannot be updated or written.
2. The system Temporary Folder directory does not have the permission to write or modify IIS Anonymous accounts. An error occurs when you access any files on the server that use Microsoft Jet Database Engine to connect to an access-type database. Normally, this error will not occur. This directory permission may be changed when you use some system spam optimization tools or other factors. Therefore, use these tools with caution.

Solution
1. Check whether the folder where Microsoft Access database files are stored has the write permission on the IIS Anonymous Account. If not, GrantWritePermission, especially when the error message is(MicrosoftJetDatabase Engine error '20140901' operation must use an updatable query..

II,JetWhen the engine connects to the database% WINDIR %/temp/Directory, while the IIS Anonymous Account% WINDIR %/temp/If the directory operation permission is insufficient, add an IIS Anonymous Account (Iusr_computer name) Pair% WINDIR %/temp/.

For other unspecified errors, you can try to re-register the ASP script to explain the link library file.
Run the following commands in sequence:
1. regsvr32 jscript. dll
2. regsvr32 VBScript. dll
3. iisreset