Web Hosting Talk







View Full Version : JET Database Engine error, Need help


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

TDMWeb
02-11-2004, 06:40 PM
Check this out:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q175/1/68.ASP&NoWebContent=1

My money would be on the permissions not being set properly on the .mdb file.