MS Access ODBC error when updating Description When trying to execute a SQL INSERT, DELETE or UPDATE command on a MS Access DB through ODBC, the ODBC driver returns the following error: DATABASE ERROR: S1000 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. Cause The folder where the DB resides has no WRITE PERMISSIONS for the IIS generic user (the one with wich IIS identify itself to Windows: IUSR_machinename). Solution Check the server DB folder "General" properties with Windows Explorer, and be sure "Read-only" is unchecked. Check the server DB folder "Security" properties with Windows Explorer, and be sure the user machinename\IUSR_machinename is listed under "Group or users name" with at least READ and WRITE permissions (FULL CONTROL if you want to be sure).