Hey! cheers for the advice...however it doesn't seem to be working, all three fields (SID, CID and GRADE) are numeric fields so i changed my query to;

sql="UPDATE STUDENTCOURSE SET"
sql=sql & "SID='" & Request.Form(SID) & "',"
sql=sql & "CID='" & Request.Form(CID) & "',"
sql=sql & "GRADE='" & Request.Form(GRADE) & "'"
sql=sql & "WHERE GRADE='" & grade & "'"

It still doesn't seem to be working am i'm still getting the "no update permissions" string displayed when i try to submit the query!

Sorry to be a pain i'm really lacking in my SQL knowledge!! ...do u think it could be something else???

Ur help is MUCH appreciated! cheers!