frontpage database edit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used frontpage 2003 to build a database entry form and also a results page.
But is it possible bulid a page where i can edit the information in the
database?
 
Yes, go to File > New > web or template then click "more web templates" and
then go to Database Interface Wizard.

Here's the contents of the Help file for Database Interface Wizard.
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.


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.
 
I just want the page where you can make change to the database. Is there
anyway of just getting that page?
 
You can manually write one, otherwise you have to go through the Wizard.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
I don't know to write one..

Thomas A. Rowe said:
You can manually write one, otherwise you have to go through the Wizard.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Then you will have go thru the Wizard, following Andrew's steps.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top