Hi Jackson,
This doesn't look right, because if your sql returns anything other that 0, your code only returns a message that write permission is lacking. It seem like your SQL could fail from any number of reason including SQL syntax. See if you can capture the actual message coming from access or VBScript.
if err<>0 then
Response.Write("No update permissions!
")
else
Response.Write("update successful.
")
LelandJ