I'm getting the following error when trying to add a new record :

Microsoft JET Database Engine error '80040e09'

Cannot update. Database or object is read-only.

/software/submitfaq.asp, line 9


The code i'm using is :

Set Con = Server.CreateObject ("ADODB.Connection")
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\InetPub\wwwroot\development\News.mdb;Persist

Security Info=False"

Set rs = Server.CreateObject( "ADODB.Recordset" )
rs.Open "Software_FAQs", Con, 3, 3
rs.AddNew
rs("CR") = TRIM(Request.Form("CR"))
rs("FAQ_Question") = TRIM(Request.Form("Question"))
rs("FAQ_Answer") = TRIM(Request.Form("Answer"))
rs("Published_by") = TRIM(Request.Form("Published"))
rs("Application") = TRIM(Request.Form("Application"))
rs.Update
rs.Close
Con.Close


I've used this code succesfully before on different projects so i can only think it's something to do with the configuration of IIS etc. I've made sure IUSER_Machinename has 'change' permission on the .mdb file but do I need to do anything else ?

Thanks in advance
Ian.