I am trying to update a microsoft access database via asp page using an update sql query.
When submitting the page the error message that occurs by using the err.number after the query executing the message is "error 424".
There is no file permission error at all. I have made sure that the database file itself has a full read and write permissions and security access rights are set correctly throughout. eg, "everyone" and "anonymous internet user" etc
The asp is running on IIS 5.0 on 2k server
The select query using the object stated below works previously on other pages to retrieve data, but not to update.
There is an object required according to the error code, but it has not become apparent to myself.
Code is below;
<h2>Submit to Database</h2>
<%on error resume next
'dim conn as adodb.connection
'dim no as string
'dim sql as string
'dim err as exception
'conn.Mode = 3 ' 3 = adModeReadWrite
if Request.form("action")="Save" then
sql="UPDATE bookings SET [CustomerName]='" & Request.Form("CustomerName") & "',"
sql=sql & "[telNo]='" & Request.Form("telNo") & "' WHERE bookings.[BookingID]=" & no
conn.Execute sql, Recordsaffected
if err <> 0 then
Response.Write("Record number " & no & " was updated.")
if you require additional source code, then please reply and this will be provided, either on this page, or in a file format in a method of your choosing.
Please help me out, this is doing my head in!!