Hello again,
I want to build a very simple database. I want people to fill out a form with their last name, place, year, etc., verify the input, approve/disapprove it and upload it. Then people could see these info on my webpage.
How do i do this, what program, if any, should I use?
Thanks in advance,
Cecilia Puchulutegui

For the database i'd suggest using MS Access, unless you anticipate lots of people querying the database at the same time (more than 10 at one moment)
You'll need to set up a connection to the database - DSN-less is the way to go, check out this page for examples www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForAccess

DMX has an Insert Record Form behaviour on the Application tab that will quickly build you the page to insert a record (there's a helpful tutorial in the help files that will explain how to fill in the dialogue box)

To verify the input you could use the built in behaviour or get the yaromat check form extension www.yaromat.com/dw/?ex=Check%20Form%20MX

If you want to have an intermediate stage whereby a moderator checks the submission then you would need a flag on each record to show whether or not it had been approved (probably also a date for auditing) and also a system to allow the moderator to login and see all submissions requiring approval.

There's quite a lot in there for you to absorb so if you need help let me know

Live the life you love
Love the life you live

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]

Hi again, Simon.
Yes, actually we would expect about 200-400 people a day in this site so I would rather be safe. It's very likely that more than 10 people check the database at the same time.
Any other program?

Access can handle 25 (in theory) concurrent connections (10 in practice) - which are requests at any given instant beyond which performance begins to fall away. If you can get away with it I would recommend going with Access as its pretty much free.

Moving up the scale in the Microsoft realm you've got SQL server, which costs lots (although you can get a developer edition for free that will allow you to build your application)

Otherwise you're looking at mySQL I think, which is a free open source database. It lacks some of the features of SQL server or Oracle - but many people use it small and large companies included.

Live the life you love
Love the life you live

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]

Hi Cecilia

Depending on when you're planning to role out the DB and if you host your own website a FREE lite version of MS SQL 2005 will be available for people to use, the beta can be evaluated here:

<b>SQL Server 2005 Express Beta 2</b>
www.microsoft.com/downloads/details.aspx?FamilyID=62B348BB-0458-4203-BB03-8BE49E16E6CD&displaylang=en

Digga

Sharing Knowledge Saves Valuable Time!!!