PDA

View Full Version : Must use an updateable query ??????



numbenator
01 Sep 2005, 05:06 AM
Hi ,

The below code



strSQL2 = "INSERT INTO commentsA (studentName,studenteMail,portal,referal,comments,entryMonth,reason) VALUES ('"&iRS("studentName")&"','"&iRS("studenteMail")&"','"&iRS("portal")&"','"&iRS("referal")&"','"&iRS("comments")&"',"&iRS("entryMonth")&",'"&iRS("reason")&"')"
Set kuUpdate = Server.CreateObject("ADODB.Connection")
kuUpdate.Open Conn
(line 27) kuUpdate.Execute strSQL2
kuUpdate.Close
cnt=cnt+1


is producing the below error

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/webwork/Student Space/archive-action.asp, line 27

Could someone better explain this please

cheers.

sajjad27s
22 Sep 2005, 07:31 AM
O Dear,

There is nothing wrong with your query. Actually the folder is write protectedin which your database is lying. You must set the write permissions on tht folder. Ask your hosting provider or use your hosting control panel for this. There must be some options for these changes.