how do i make a working form in frontpage2003 and then have the information go into a database?

Question

i am making a website for part of my school that requires a registration form - i ahve made the form but i cannot seem to make it work so that the information will be sent to a database of some sort either excell or access

Answer 1

It’s not that simple. When you connect databases to your web page, you need ASP or JSP to access the databases. So front end is ASP and backend is MS Access. I’ll brief you how it’s working. There are lots of methods. This is just a one method shown in steps.

1. Install the web server (IIS, Resin, or what ever you use)
2. Design the web page with server side language (ASP, JSP, PHP, etc)
3. Create the database (MS Access)
4. Crete a DSN (Data Source Name – This is the fastest method)
5. Edit the web page so it refers to the DSN
a. Connect to database
b. Create SQL statement
c. Load SQL with values in form
e. Update the DB with SQL (INSERT IN TO …..)