16/05/2002, 03:47
| |||
| |||
| Operation must use an updateable query. ??!! Ese es el mensaje que me sale cuando intento en asp.net ejecutar un código de inserción de datos en una tabla... ¿Debería tocar algo en el IIS que permita que las tablas sean actualizables?, he intentado entrar en las propiedades del archivo mdb, pero todo parece correcto. Estoy convencido de que es un problema de fácil solución, pero no la encuentro... Gracias por vuestro tiempo. Saludos. |
|
16/05/2002, 04:23
| |||
| |||
| Re: Operation must use an updateable query. ??!! Ok, solucionao: http://www.macromedia.com/support/ultradev/ts/documents/80004005update.htm Era: Issue The following error: 80004005 – Operation must use an updateable query – occurs on a page when an event is updating or inserting into a recordset. Solution There are several things that may cause this ODBC error. Many of the possible reasons are listed in the table below. The permissions that are set on the directory the database is in. IUSR privileges must be set to "read/write". The permissions on the database itself does not have full read/write privileges in effect. This error can also occur when the database is located outside of the inetpub/wwwroot directory. Though the information is still able to be viewed and searched, it cannot be updated unless it is in the wwwroot directory. The recordset itself was based on a non-updateable query. If you have non-updateable queries within your database (joins are a good example) - this could be the cause. You would actually have to restructure your queries so that they are updateable. Additional information For additional information on this error, please refer to Microsoft's Knowledge Base... Espero que os haya sido útil. Salvador Gallego. |
y revisa los permisos que tienes sobre la base de datos o sobre esa tabla en concreto. 
