</body> </html>

Finally, you need a page to read and display the entries from MS Access. The view_guestbook.asp page queries the database and loops through the results.

Open Microsoft Access and create a new Blank Database . Save it as Guestbook.mdb or Guestbook.accdb .

' --- Database Connection String for MS Access (.mdb) Dim conn, connStr, sql Dim name, email, website, message, ip

' Execute the command conn.Execute(sql)

GuestName (Short Text/Varchar): To store the visitor's name.

' Execute the insert conn.Execute(sql)

' Redirect user to the view page Response.Redirect("

?>

Here is a classic example of how to write that data into MS Access. You would save this as add_entry.asp .

<% ' Declare variables Dim conn, sql, name, email, comments