creating asp pages to go into access db

[NeilBelgium]

Although there are so many projects I WANT to start, here's the one I'm currently committed to!:

I need to set up data access pages (or similar!) so that various people can give feedback (mainly numerical)
to other people. Very similar to the technology used for rating experts on this site?

I see the project as being a two-parter (and, as you can see, i'm willing to blow some points on this
one!):

Firstly, the quickest way to set up forms to collect the info, going directly into the db.

Secondly, how to set up the backend db.
I've got about 50 questions, rated 1-5, the answers of which are grouped into ten categories. ie. I
need to be able to add the sum of questions one-five to get a total.
This wouldn't be so hard, but the form can be filled in by several people, so how would I set up the
tables?

If anyone has done this kind of thing before, I'd love to know. eventually I waqnt the access db to
produce indivdualised reports, with one of a number of possible pre-typed comments,and some graphical
display of the scores, but this is the last part, and collecting the data properly is the key challenge
for now.
A lot of ASP tutorials presuppose the ASP pages are taking info from the db and displaying it, though
what i'd like to do is rather the reverse - filling my db with people's direct input. There may even
be simpler methods than ASP for this.

Finally, although I'm pretty certain to use the asp/access/iis method (hence posting to this group!!),
is there a simple software package that can do a lot of the hard work as i'm up against time? I've
been recommended ultradev, but really would like some feedback before spending all that cash!

many thanks, neil

 

[GIGN]

"...though
what i'd like to do is rather the reverse - filling my db with people's direct input... "

Using INSERT you mean? This is as simple as getting the data
fro the database - perhaps you ad a bit of client side data verification and update away. I wonder maybe if you need to actually store too much actually in the database.

Perhaps just store each persons data in Session, and kill it on timeout, or keep a record, whatever the case may warrant.

ASP is definately one of the ways to go here, after all you need server-side manipulation. The other is PHP, but it's the same with a few different features.

UltraDev is available as a free trial - that wouldn't hurt, it's fully functional.

Try updating your data using ASP, you'll find it is pretty straight forward - there should be tutorials for this [and all other aspects] wherever you have got your others.