error:operation must use an updatable query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am facing an error Inserting data into the database.I am using cgi-perl and
access as the database.The error says "Operation must use an updatable
query".When I searched google I found some sol. but it didnt worked.....which
says that there are some permissions required for guest user.The server is
IIS.Please help if possible.
 
The security context in which the Perl script is running must have at least
Read, Write, eXecute and Delete permissions on the folder where the MDB file
exists.

This is a common problem with ASP code. In that case, the ASP code is
running as IUSR_<machinename>, but I don't know if it would be the same user
id in your case.
 
whenever i get 'operation must use updatable query' i've found it to be
something wrong in my query that isn't working right or a table that i
joined inproperly. if you want, paste the query and maybe that will
lead to the evil in the error message.
 
Back
Top