Table of Contents   Setting Up Database   Setting System DSN   Setting Folder to Execute 
Microsoft Office Family MemberActive Server Pages Sample Web

   Creating ASP File       Creating Forms        Viewing Your ASP

Microsoft FrontPage 98

Setting Up Your Database

 

   Where To Store Your Data

 

   The MicrosoftAccess database used in this example is stored in the "_private" directory of this web. When working with your own database, you should store database in a directory that is not accessible through a web browser. The most secure arrangement is to not have the database within the web content folder at all, instead placing it somewhere else on the hard drive (C:\Webdata). For more information on how to do this, see
"Setting Up an ODBC System Data Source Name".

  

   Use a Table

   To make your data accessible, it must be stored in a table. The Microsoft Access database
included in this example contains a table named Employees.

img0007.gif (9361 bytes)

 

 

   Populate the Database

   After you design the table, you can fill it with information. In this example, the table is already filled with employee information.

img0008.gif (16393 bytes)

 

 

Back Back      Top Top   Next Next

           Microsoft Software for the Internet © 1997 Microsoft Corporation
All rights reserved. Legal Notices.