I'm new to ASP and sql. I'm trying to create a simple ASP script that updates records on MS Access db file. Whenever I try to test it, I get an error: "Operation requires updateable query", and the line it's referring to is [var recSet = objConn.Execute(sqlString);].

My sql string is:
"UPDATE Clients SET FirstName='John' WHERE FirstName='Joe';"

-------------

->Is it ok to use same field name for SET and WHERE?
->Is this why I'm getting an error?

Hello,

  This is due to insufficient privileges on the database or virtual folder. Check the privileges. Or database may be readonly

--------
Rajani

Hello,

I've checked the permissions of all related folders (and db file), and found out the write permissions are enabled. Also, when I use the same sql string on my script on SQL view of MS Access, it is able to update the DB. What other privileges can I check? What else can I do?

---------

Mark

Does the I_USR<machine_name> have access to write to the folder of the DB?