[AccessD] Access data to and from Website

Hi all,
I have no experience with pushing data between an Access database and a Website.

We have a full featured event management database that we have been running for
some years - still in Access97 about to be moved to A2003...

A number of conferences are held throughout the year.
An organization registers one or more attendees
An attendee is assigned to several sessions throughout the conference.

All registration related communication used to be handled with postal mailout,
now most is done via email.

However, de peple in de top office is reguesting that an attendee should be able
to visit the website (currently just a static web page) - view all sessions for
the conference and select which ones they wish to attend, and submit this
information.
Relevant procedures will then integrate the information captured into the event
database.

Something needs to be up and running rather quickly.

I'd appreciate anyone's comments, suggestions for a simple, quick and efficient
solution.

What tools to use?
Estimated time involved?
Code samples

This is how I envisage the functionality:

The Attendee enters LastName, FirstName, City and emailaddress.
Entry is validated against table containing data for all attendees for the
Conference: AttendeeID, LastName, FirstName and City (we may not have email
address at this stage). As part of the validation the AttendeeID is identified.

The list of sessions are displayed grouped by Date and Session Category and
order by StartTime.
There is a tickbox (?) for each Session where the Attendee can tick if he/she
wishes to attendee the Session. Each session is identified by a SessionID, (not
necessarily displayed).

At the bottom a Submit button.

Curious as to how do you make this part of the webpage dynamic/interactive -
i.e. the code behind the submit button to walk the page, identify the sessions
that have been ticked and capture the corresponding SessionID



The submit button will do the following:
1. Send an email confirming Name, City and listing the Sessions that the
Attendee wishes to attend.

2. Capture information from the Webpage to a table called say
tblWebRegistrationAttendee
AttendeeID
emailaddress

(no editing of Name and City information)

and to a table called say
tblWebRegistrationAttendeeSession
AttendeeID
SessionID

The captured information will then be copied from the webserver tables to the
event database for further processing.....

.... that's it
any suggestions, comments, pointers appreciated

regards
/borge