Ms Access Guestbook Html -
<html> <head> <title>Guestbook</title> </head> <body> <h1>Guestbook</h1> <form action="guestbook.asp" method="post"> Name: <input type="text" name="name"><br> Email: <input type="text" name="email"><br> Message: <textarea name="message"></textarea><br> <input type="submit" value="Submit"> </form> </body> </html>
' Close connection conn.Close Set conn = Nothing ms access guestbook html
<%@ Language=VBScript %> <% ' Connect to MS Access database Dim conn, rs Set conn = Server.CreateObject("ADODB.Connection") conn.Open "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Path\To\Guestbook.accdb" form action="guestbook.asp" method="post">
' Get form data name = Request.Form("name") email = Request.Form("email") message = Request.Form("message") input type="text" name="name">
' Redirect to guestbook page Response.Redirect "guestbook.html" %>