error:operation must use an updatable query

A

amit

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.
 
D

Douglas J Steele

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.
 
R

roadie.girl

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.
 
Top