[AccessD] Access data to and from Website

To get up and running quickly maybe try classic ASP?   The code behind is mostly VBScript so it's syntax you'd be familiar with.  4guysfromrolla.com or asp101.com should get you started.  

On a more modern front ASP.NET is the latest/greatest and supercedes ASP.  If you want to play with either set up a free account at brinkster.com.  You can do ASP in anything from notepad to a dev environment like Visual Interdev.  Visual Studio .NET is the tool for ASP.NET.  There are other choices for both (do a google and lo and behold...).



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Borge Hansen
Sent: Wednesday, November 30, 2005 10:03 PM
To: Access Developers discussion and problem solving
Subject: [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



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************