Connecting website to an access database

[Guest]

I am fairly new to FP, however am very familiar w/ other MS office products (Excel, Access, etc...) I am using FP 2000.

I have built a website for my small business and would like to add a page to capture visitor contact information via a user form. I have been trying to do this by using the wizard that's built into FP thinking that w/ help. When I build it I set up the BE database to where the data is supposed to be stored. However, when it's published to the net it doesn't save any data to the database itself.

I know this may be vague however I don't know how else to phrase it. I've tried all of the on-line help thru FP and Access as well. Not getting me anywhere so I thought I'd try here.

I'd appreciate any feedback you might have.

Thanks,

Ron

 

[Andrew Murray]

The basic method:

1) create a html form on a new page, name your form fields etc etc
2) right-click the form and choose 'send to database'.
3) Click the "create new database" and choose the fields you want to use.
4) click ok out of the dialogues and save the page (it will probably tell you to
save as *.asp - so do this).
5) publish the asp page, and the *.mdb file (to the fpdb folder as default, or
whereever you like if elsewhere).
6) view the asp page in your browser, you should be able to enter the data and if
you've set up the confirmation pages or not (it will display the default confirm
page, or your custom page).
7) Create new page, the select Insert > Database > Results
8) Follow the wizard through the steps...if you know sql you can make a custom
query or choose from options Frontpage offers.
9) choose the (simple) layout for the results
10) finish off the wizard - then you can modify between the results area the
layout of the results, eg apply styles, fonts, table layout etc.

save with *.asp extension publish this page

View the page by typing in the url - if you have let the results wizard insert a
search for, put in a search string for data you know is in the database, click
'search' and it should return the results.

Since you're familiar with Access, you can set up your database structure (tables
etc) in Access, then create the html form with field names matching those in
Access. to keep it simple make them all text fields (as access can have
different data types like number, currency, real number, integer, date, etc).

I recommend the tutorial here www.frontpagewiz.com on using databases with
frontpage.

I am fairly new to FP, however am very familiar w/ other MS office products

(Excel, Access, etc...) I am using FP 2000.

I have built a website for my small business and would like to add a page to

capture visitor contact information via a user form. I have been trying to do
this by using the wizard that's built into FP thinking that w/ help. When I
build it I set up the BE database to where the data is supposed to be stored.
However, when it's published to the net it doesn't save any data to the database
itself.

I know this may be vague however I don't know how else to phrase it. I've

tried all of the on-line help thru FP and Access as well. Not getting me
anywhere so I thought I'd try here.