Must use an updateable query ??????

[numbenator]

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]

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.