Getting an Access DB order form to work with Fp Ext.

[gaffer]

I appologize for posting this to more than one group. It was origianally
sent to: microsoft.public.frontpage.fp2k.programming but that group seems to
be full of junk postings.

I have a current db designed with Access2003. The db contains three primary
linked tables that store reservation information for special intrest cuises.
The tbl "reservation" conatians cabin, prices, deposit and credit card
information. Tbl "pass1" containts contact information for the primary
cabin passenger. Tbl "pass2" contains the same info for a 2nd passenge.

I designed a data input form that populates the three tables. It works
wonderfully when taking orders over the phone. We have set up a website and
would like to add this form and have customers enter the reservation info
themselves.

the website is currently hosted by GoDaddy and they claim to have "Access
database support enabled through Frontpage extensions". Can you give me any
clues as to how I can publish this input form on a web page.

Thanks in advance for any help,

Gill

 

[p c]

You need to connect to the database through a connection string and you
need ASP.

For example page one is the form which passes information to page 2.
Page 2 contains asp script, it grabs the information form the form, foes
calculations or manipulations then updates the dadabase through a
connection string. It can also provide a confirmation or warnings for
failures.

Search for ASP and database. I suggest that yo do your script code in
HTML mode or in notepad. FP screws up non-HTML code.


....PC