Hi All,

I am getting an error with the following code, can any one advice me what is wrong in this code, the error I get on line "rstGuestBook.AddNew"
the aim of this code is, will add a new record to my GuestBook.mdb File.

this is the code:

Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "2bs-GuestBook"
mySql = "SELECT * FROM GuestBook"
Set rstGuestBook = myConn.Execute(mySql)

rstGuestBook.AddNew

rstGuestBook("Nmae") = Request.Form("txtName")
rstGuestBook("Email") = Request.Form("txtEmail")
rstGuestBook("Company") = Request.Form("txtCompany")
rstGuestBook("Url") = Request.Form("txtUrl")
rstGuestBook("Comment") = Request.Form("txtComment")

rstGuestBook.Update

rstGuestBook.Close
Set rstGuestBook = Nothing

myConn.Close
Set myConn = Nothing

Response.Redirect("guest_book_Thanks.html")


BR