kami
02-11-2004, 06:33 PM
Hi,
I am having some difficulty resolving a ms-access database problem which is not ensim related but hoping someone could give me some input on it.
The problem is that when I try to write into database via a submit form I keeps getting the following error:
---------------
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/questions.ASP, line 32
-------------------------------
The line 32 is:
connect.execute "INSERT INTO QUESTIONS ( CATEGORY, AUTHOR, QUESTION) VALUES ('" & Request.Form("CATEGORY") & "', '" & Request.Form("AUTHOR") & "', '" & Request.Form("QUESTION") & "' )"
Can someone shed some light on this error and possibly tell me how to fix it.
Thanks
I am having some difficulty resolving a ms-access database problem which is not ensim related but hoping someone could give me some input on it.
The problem is that when I try to write into database via a submit form I keeps getting the following error:
---------------
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/questions.ASP, line 32
-------------------------------
The line 32 is:
connect.execute "INSERT INTO QUESTIONS ( CATEGORY, AUTHOR, QUESTION) VALUES ('" & Request.Form("CATEGORY") & "', '" & Request.Form("AUTHOR") & "', '" & Request.Form("QUESTION") & "' )"
Can someone shed some light on this error and possibly tell me how to fix it.
Thanks
