Error "Operation must use an updateable query" reason and solution

xiaoxiao2021-03-06  169

Error message: Microsoft OLE DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC Microsoft Access 97 Driver] Operation Must Use An Updateable Query. Reason: There are several major error reasons: this error occurs when your program is trying Perform update databases or other similar operations. This is because ADO cannot be written due to the following reasons.

0. Data file read only?

1. The most common reason is that anonymous user account (IUSR_MACHINE) has no write permissions to the database file. To solve this problem, adjust the properties of the database file in the manager, so that anonymous users have correct permissions. When using the Access database, not only gives the permissions written by the file, but also give this directory, because JET needs to create a .ldb file in this directory. 2. The second reason is that the database does not open the correct mode. You should open the following method. SQL = "Update Products Set Unitprice = 2;" SET CONN = Server.createObject ("AdoDb.Connection") Conn.Mode = 3 '3 = AdmodeReadwrite Conn.open "MyDSN" Conn.Execute (SQL) Conn.close pay attention to the default Mode is set 0 (AdmodeunkNown), which is allowed to update. 3. It is also possible to select the read-only option of the DSN in the ODBC manager. 4. You are updating the fields in the two tables at the same time, and this error message will appear, the solution is to update the respective fields in these two tables. 5. When you use a query from a low version (such as access2.0, access7.0) to a high version (Access 2000), the error will appear.

转载请注明原文地址:https://www.9cbs.com/read-128366.html

New Post(0)