ASP insert, edit and delete driving me mad

[jennyWren]

Hi

Yesterday I opened an account with WH UK to host my web site. All asp files have now been uploaded and an Access database uploaded with a dsn connection set.

Select statements work with no problems, data from the database gets displayed to screen ok - although I have noticed that all my dates are appearing to screen in US format, when they were in uk format in the local environment.

Anyway, testing my pages via my web address has shown that my insert, update and delete functionality is not working since I made my connection to database with DSN - it was mappath in the local environment and everything worked smoothly.

The insert and update error message I get is -

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/appointmentsDay.asp, line 565

whilst the delete error message is -

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.

/admin.asp, line 221

Do you think it is something to do with the new account or a scripting problem?

Thanks, I need to get this sorted out by Thursday for a job interview.

[jennyWren]

The code to insert looks like this

set conn=Server.CreateObject("ADODB.Connection")
conn.Mode = 3
conn.open "creaturecomDSN"


Dim records
conn.Execute "INSERT INTO appts(timeAppt,dateAppt,clientIDAppt,patientIDAppt ,roomNo) Values" & _
"('" & varTime & "','" & varDate & "','" & varClient & "','" & varPatient & "','" & varRoomNo & "')" , records


Is there anything wrong with it for a dsn connection?

[jennyWren]

Eventually I got read/write permissions on httpdocs from WH UK - a day later, what a waste of time. But now I can delete, update and insert ok. The matter is now sorted.