Angela Johnston
CIS 798 Project
Faculty Database Application

Tutorial

In order to create an ASP Database application, you must be able to create a  connection to your database, and connect to it from within your ASP page.   There are several ways to create a Connection to an Access database using Frontpage.

First, You can use the Microsoft FrontPage Wizards.  Second, You can use Microsoft FrontPage to create a connection to an Access database.  Third, You can create your own DSN-less connection.

This tutorial contains the following steps:

1. Learn how to use the Microsoft FrontPage wizards to create a simple form connected to a database.
2. Learn how to use Microsoft FrontPage to create a Database connection.
3. Learn how to open a database connection using either a Microsoft FrontPage connection or a DSN-less Connection.
4. Learn how to use an open database connection, and recordsets to allow an ASP page to interact with the database.

1 Creating a Form and Access Database Using Microsoft FrontPage Wizards

2 Using Microsoft FrontPage to Connect to an Access Database

• 2.1  Create a Connection while importing the Database into your web site
• 2.2  Create a Connection to a Database already stored in the Web Site

• 3.1  Open a DSN-less Connection using a FrontPage Connection
• 3.2  Open a DSN-less Connection without using a FrontPage Connection

4 Using Recordsets to Interact with the Database inside of an ASP page

• 4.1 Creating an Include page containing the DSN-less Connection
• 4.2 Creating a Form page (front end)
• 4.3 Creating an ASP page to store the results in the database (back end)
• 4.4 Displaying the information in the database