Using the Database Interface Wizard with ASP

Microsoft Office FrontPage 2003

Show All Show All

Using the Database Interface Wizard with ASP

Important   The following procedures will not work on a Web site located on a server running Microsoft Windows SharePoint Services.

By using the Database Interface Wizard on a Web site hosted on a server running Active Server Pages (ASP), you can create Web pages to add, edit, or delete database records. You can also specify a password to help protect those pages.

Security  Use this feature with caution. Sensitive or confidential information could be revealed to others, such as other authors of your Web site, or site visitors on the Internet or your intranet.

ShowStart the Database Interface Wizard

  1. On the File menu, click New.
  2. On the New task pane, under New Web site, click More Web site templates.
  3. Double-click Database Interface Wizard.

ShowSpecify ASP as the server technology and a database connection

  1. In the FrontPage has detected that your page will display best using area, make sure to select the check box for ASP, so that your pages will work correctly on a Web site located on a server running ASP.
  2. Specify the database connection you want.

ShowSelect the table or view and where it will be stored

  1. In the Select the table or view you would like to use for this database connection list, click the table or view you want.
  2. In the Specify a location for the new files box, type a path to a folder in the active Web site to store the pages for adding, deleting, and editing database records.

ShowSpecify the database columns and form fields

  • Under Edit form field type list, you can add, modify, delete, or change the order of the database columns and the corresponding form fields used to edit or update those fields.

Notes

  • If you clicked Create a new Microsoft Access database within your Web site on the first page of the wizard, the page to specify columns and fields will appear sooner in the wizard.
  • Some options might be unavailable. For example, if you clicked Use an existing database connection on the first page of the wizard, the option to add new columns is unavailable.

ShowSpecify the pages to create

  • Select the pages you want the wizard to create for you.

Notes

  • When you select the pages you want the wizard to create for you, if you select either the Submission Form or the Database Editor check box, you can create pages to add, edit, and delete records. Likewise, if you select the Don't password protect my submission form or my database editor with a username and password check box, any site visitor can add, edit, or delete database records.
  • Even if you do password protect this page, there are still security risks. Refer to FrontPage Help to learn more about database and security best practices.