Insert statement in ASP

[kazai]

I have an insert statement which is perfect..I run it on Access, and it gives me the correct o/p.(ie, it inserts.) I saw the string on the browser, and copy-pasted it onto Access, and it works.
But if I do a conn.Execute(strSQL), it gives me an error saying "Query must be an updatable one". Now I found that a random user must have permission to insert into the table. But this permission was granted, and it still gives the same message. Can anyone tell me why?
ThankYou,
Radhika.

 

[krappleby025]

I believe you are producing the string as

strSQL="insert blah blah blah"

try the following

strSQL=conn.execute("insert blah blah blah&quot

may help