Hi Kathy,
In help:
Hide 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) (ASP: Active Server Pages.
A server-side scripting technology that is used to create dynamic interactive Web applications. An ASP file is an HTML page
containing scripts that are processed by a Web server before being sent to a browser.), 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.
Start 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.
Specify 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.
Select 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.
Specify the database columns and form fields
a.. 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
a.. 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.
b.. 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.
Specify the pages to create
a.. Select the pages you want the wizard to create for you.
Notes
a.. 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.
b.. 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.
