cmd.Execute (insertQuery) !!

[hspc]

Hi
I use asp , ado , AccessXP db to make an online registration system.
I created an Insert query in the Access database and call the query like this :

set con=Server.CreateObject("Adodb.Connection")
con.ConnectionString = strCon
con.CursorLocation = 2 'Server
con.Open
.
.
.

set cmd=Server.CreateObject("Adodb.Command")
set cmd.ActiveConnection=con
cmd.CommandText="InsertCustomer"
cmd.CommandType=4'adCmdStoredProc
cmd.Execute ,Array(n,Request("FirstName"),Request("LastName"), Request("Email")


it works fine on localhost .. but when I upload the asp , mdb and try it online i get the error :


Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/register/save.asp, line 62

:confused:

can anyone help please ?

[eduardo7095]

This is a simple IIS permissions problem. Make sure the database itself has read/write/modify permissions as well as the directory where the database lives

Hopes This Helps

[hspc]

Thank you..
I've already solved the problem.
and yes ,, it was a problem of permissions.
thank you again.