Error Type Microsoft OLE DB Provider for ODBC Drivers 0x80040E21 The required attributes are not sup

microsoft jet database engine (0x80004005)

The operation must use the Update query.

This error usually occurs when adding, deleting, or updating a database because the viewer of the page does not have the proper permissions to operate the database.

Let's use the screen of Windows XP Professional to illustrate the solution:

Please go to the File Explorer screen and click [Tools] Folder Options].

Select the [View] tab and disable [Use Easy File Sharing] for [Advanced Settings].

Please select your library file, press [Right-Click] at the top and select [Content].

Select the [Security] tab and press the [New] button to add a new user.

Please create a new Internet viewer account, its format is iusr computer name, how to know the name of the computer of the machine, as shown in the figure below in [from this position] is the name of the computer, so we enter iusr n800c in the field, and then press the [OK] button.

As shown in the figure below, there is an Internet guest account, please select the account below, you can check the [Full Control] below, and then press the [OK] button.

This completes the setup.

Note: The new account name is iusr computer name, but there are many people who artificially enter it as iuser computer name, which is wrong, please pay attention.

Resources.

Generally, it is a problem with the permissions of the directory where the database is located.

Common errors in ASP 80004005 information and solutions.

How to handle errors 80004005 information.

Error information (I don't need to translate the error message into Chinese, hehe, everyone understands).

microsoft ole db provider for odbc drivers error ’80004005’

microsoft][odbc microsoft access 97 driver] the microsoft jet database

engine cannot open the file ’(unknown)’.it is already opened exclusively

by another user, or you need permission to view its data.

Cause: This error occurs when IIS uses an anonymous account (usually IUSR) that is in NT to the directory where the database is located.

There are no correct permissions. (That's why it's okay under Win95 and PWS, because Win95 doesn't have directory permissions at all).

Check permissions for files and directories. Make sure you have permissions in the directory to create and delete temporary files.

These temporary files are actually files that the database is created in the same directory, but be aware that these files may be filed.

It may also be created in another directory, such as winnt

Use NT's File Monitor to monitor exactly what directory was accessed when a file failed.

If you use a network address for the database, such as a mapped address, check the permissions for shared files and directories, and check if the data source file (DSN) is marked as in use by other programs, such as visual interdev, which closes any interdev that is open to the database.

This error can also happen if you are using a UNC path (i.e. the Universal Naming Protocol) in your DSN, use it instead.

Local path, as errors can also occur if you use unc for your local database.

This can also happen if the server wants to access a table in Access, and the table is joined to a web server.

microsoft ole db provider for odbc drivers (0x80004005)

Microsoft][ODBC Microsoft Access Driver] cannot be updated. The database or object is read-only.

Reason analysis: Some people say that the read-only box is selected, but in fact the folder is not really a read-only file, because if it is really a read-only file, it should be a checkmark in the box, not the default box selection.

For Windows XP 2003, Windows Explorer does not allow you to view or change the "read-only" or "system" properties of folders. This does not mean that the folder is read-only by default, it is verified with attrib, and the folder does not have an r attribute. While you can re-select or empty it, you can't really modify read-only properties.

If you really want to modify the folder attributes, you can use the attrib command in dos, for example, you can use the command "attrib +r c: 1" to increase the read-only attribute of directory c: 1.

The real cause is a folder permission issue. This problem occurs in the NTFS file format.

Solution:1Folder – Attributes; Or, Explorer – Tools – Folder Options.

2.In the View tab, uncheck Use simple file sharing. In this way, right-click on the NTFS partition folder under XP, and you can also see the "Security" tab like Win2000.

3.Under the "Security" tab, click on "Add ......Jumps out of the Select Users and Groups dialog box.

4.Add everyone, everyone can use the default permission, if the error is still reported, you need to set everyone's permission to full control.