ADO ERROR: Operation must use an updatable query

[ShIzO]

Hello friends,

I have a question this ASP runs on ADO 2.1 & 2.5 but it dues not run on ADO 2.0
When i run it on 2.0 i get the following error:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query.

/howyoucanhelp/submit.asp, line 15


And here is my ASP trouble code :


set objDBConn=Server.CreateObject ("ADODB.Connection")
objdbconn.Open "Petition"

strSQL = "Insert Into Petition (Name, Address, _
City, State, Zip, Email)
Values ('" & Request.Form("Name") & "', '" & _
Request.Form("Address") & "', '" & _
Request.Form("City") & "', '" & _
Request.Form("State") & "', '" & _
Request.Form("Zip") & "', '" & _
Request.Form("Email") & "')"
objDBConn.Execute (strSQL)
objDBConn.close
set objDBConn = nothing



Shall i use Recordset to make it work or what?
Please help. I need to get it running on MDAC 2.0!
Thanks

[Clunietp]

put brackets around the NAME column:

"Insert Into Petition (Name, Address, _
City, State, Zip, Email)


should be

"Insert Into Petition ([Name], Address, _
City, State, Zip, Email)

also make sure your IUSR_MachineName (on your server) has change permission on the directory that the DB resides in

[ShIzO]

[ShIzO]

I tried the above and I get the following error now:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] Couldn't lock file.

/howyoucanhelp/submit.asp, line 10

[Clunietp]

Does the IUSR_MachineName have change access to the Directory that the DB resides in? Just setting the permissions on the MDB file is not enough.

[ShIzO]

Yes it does, i have changed the permissions to read+write for that folder thru NT Explorer.

Thank you for help.

[ShIzO]