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.

Have you ever been able to successfully perform an update on this particular database? If not then it probably has something to do with the fact the windows user "IUSR" has insufficient rights to "write" to the folder containing the database. Check out your permission, if the IUSR has the proper access, it may be something else.

D

yeah , I have actually just overcome problem.
Database had permissions set but server required additional setting in IIS as using ASP.
Cheers for you input though.
Steve

Right click on the database and change permission.
Most Windows hosting set correct permission for your database.
Mostly the error occurs on localhost ;-)