2 Using FrontPage to Connect to an Access Database

Back to Tutorial

2.1  Create a Connection while importing the Database into your web site

  1. Select the Import option from the File menu. (see Figure 1)


    Figure 1
     

  2. Push the Add File button in the Import menu.  (see Figure 2)
     

    Figure 2

  3. Select your access database in the Add File to Import List menu. (see Figure 3)
     

    Figure 3
     

  4. Press the Open button in the Add File to Import List menu (Figure 3), and press the OK button in the import menu (Figure 2).

  5. A question box will pop-up and ask whether you want to create a new database connection.  Type a descriptive name for the database in the text box labeled Name.  Remember this name. It is the name of your connection, and it will allow you to connect the database to your asp pages. Select the Yes button. (see Figure 4) 
     

    Figure 4
     

  6. Another box may also pop-up and ask whether you want to save the database in the "fpdb" folder.  Select the Yes button.
     

    Figure 5
     

  7. There should now be a folder called fpdb with your access database stored inside.

2.2  Create a Connection to a Database already stored in the Web Site

  1. Select the Web Settings option from the Tools menu. (see Figure 6)
     

    Figure 6
     

  2. Select the Database tab inside of the Web Settings menu. (see Figure 7)
     

    Figure 7
     

  3. Select the Add button from the Web Settings menu. (see Figure 8)
     

    Figure 8
     

  4. Type a descriptive name for the database in the text box labeled Name.  Remember this name. It is the name of your connection, and it will allow you to connect the database to your asp pages. (see Figure 9)
     

  5. Select the Browse button to find your Access Database location in the current Web.
     

    Figure 9
     

  6. Select your access database and push the OK button. (see Figure 10)
     
     
    Figure 10
     

  7. Continue pressing OK buttons until you have exited all of the menus.  You have now finished creating your database connection.