When trying to execute an update query in ASP, the server returns the error 'Operation Must Use an Updateable Query', when the server is running some advanced OS (NT, XP, 2K; not 98, ME)

The problem is around the server files and folders security, more specifically the users permissions.

When you access the server via the web browser, the server assigns you the Internet Guest account or user. This user must have read/write permissions over all the files/folders used by the Jet engine (if you are using Access).

The Internet Guest account name is IUSR_[server_name] or [server_name]\IUSR_[server_name].

The files that must have read/write permission for this account are: the database (.mdb), the folder containing the database, and eventualy the system temp folder (usually c:\temp).

More info Microsoft Knowledge Base Article - 175168.

More info Edit user access permissions for files/folders.