I have a simple form coded in VBSCRIPT that has 16 form fields and a file upload input. The way it works now is that when you submit the form it emails the form data to an email address and stores the uploaded file on the server. I still want it to email, but I also want it to be stored in the database you are creating.
I need you to hook up a database to the form so when someone submits the form, all of the form data gets put into the database and also sends an email. Then you also need to create a simple password protected admin area (username and password login) where you can view all of the form submissions so our client can login and view all of the submissions. Please also include the date of the submission with each one.
The form has a file upload box that copies the file to a folder on the server. In the admin area, if you view a submission that has a file attachment you should provide a link to the file attachment.
Just to repeat, the form is already coded in VBSCRIPT and has the email functionality. All you need to do is hook the form up to a database and create a simple admin area.
**The database needs to be compatible with SQL Server 2000.