Cannot update. Database or object is read-only

[tox]

Hello, I developed the following asp code with one ISP-Streamelinenet; it worked fine, in fact it NEVER failed not once! Then I moved the code to the ISP where it will actually be-Supanames; and it keeps giving me the same error:

Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/tavialecom/property/enquiry.asp, line 106

Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open "Enquiry", sys_oConn, adOpenStatic, adLockPessimistic, adCmdTable
rs.AddNew <<<------------ line 106
new_id = sys_GetNextID(sys_oConn,"Enquiry","ID",Start_ID)
rs("ID") = new_id
rs("FullName") = strFullName
rs("Fulladdress") = strFullAddress
rs("Telephone") = strTelephone
rs("Email") = strEmail
rs("Fax") = strFax
rs("Enquiry") = strEnquiry
rs("Comments") = strComments
rs("Referrer") = strReferrer
rs("Replyby") = strReplyBy
rs("Date") = Date
rs("Time") = Time
rs.Update
rs.Close
sys_oConn.Close
Set sys_oConn = Nothing

I have no capability to test asp scripts on my PC- everything was tested online, the code and database was loaded and reloaded, and tested several times (adding fields, to tables etc) without ever a problem, until I loaded the finished working website onto SUPANAMES ISP. They use Windows Server 2003 .NET framework enabled server Virtual server type: IIS 6.0.
Please, any ideas ?

[russell]

1. make sure they didnt set dsn to read only
2. make sure db is not read only
3. make sure directory db is in is not read only

[tox]

Thank you, I will add suggestions to the long list (been searching google for 8 hours) of actions I emailed to the ISP.
The files and folders are not read only on my PC. Might they change their read/write permissions when uploaded onto a specific webhoster?

Interestingly, while using my FTP (AbsoluteFTP 2.3) software, the old ISP shows the MDB file and all folders having '700' permissions. The 'new' ISP won't allow the software to view/change file permissions. On right-click, the 'properties' menu option is greyed out for all files and folders (ie. unselectable).

I dont think its a connection issue because website pages that do not modify the database are fine ie. they display the DB's data perfectly through the asp pages. Thanks again.

[tox]

Resolved. I needed to create a file DSN from the new servers control panel before, I was able to write access the DB.
I think this DSN File mapped the path to the Access DB, eg. I had to fill out a form requesting 0.Name for this new DNS File connection 1.the path to the database 2.the database name 3. the database password (though I hadn't developed the DB with one). This worked 1st time.
Thanks again for the help and advice.