Microsoft Jet engine trouble

[ButtHead]

Please help me if you can!

My ASP database connection doesn't work properly.
table name is "guestbook"
fields are ID, firstName, lastName, e-mail, URL

Dim connect, record
Set con=Server.CreateObject("ADODB.connection")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("guests.mdb")
Set record=Server.CreateObject("ADODB.Recordset")
record.Open "SELECT * FROM guestbook", con
record.AddNew
record("firstName")=firstName
record("lastName")=lastName
record("e-mail")=Request.Form("e-mail")
record("URL")=Request.Form("URL")
record.Update
record.Close
con.Close

IIS gives something like this: Microsoft Jet engine can not find the 'URL' object, check if this object exists or may be its path is incorrect!

Help me if you can !

[Tumanyan]

I dont' know exactly, what's going on in your case, but, there is a thing, which confuses me (maybe, that's the source of error)
You're executing SELECT statement, which (IMHO), returns read-only recordset. After that, you're trying to modify and update result of SELECT execution. I'm not sure, if Microsoft JET engine supports it or no.
Anyhow, at least it is direction to dig in.
I hope, this will help.

Regards,
Hovik

[ButtHead]

Dear Tumanyan

That wasn't the exact code i was using - please see this one -

Dim con, record

Set con=Server.CreateObject("ADODB.connection")

con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("guests.mdb")

Set record=Server.CreateObject("ADODB.Recordset")

record.Open "SELECT * FROM guestbook", con

record.Close
con.Close

see this one doesn't do anything smart, but error message is the same: that microsoft jet engine cannot find the 'URL' or whatever object that is the last field in my guestbook table!

I'm running XP - maybe here what's the problem?