• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

How do I use html forms with an Access database?

T

timswim78

Diamond Member
Hi,

I am working on the thesis for my Master's degree, and my experiment involves having users read a passage and then answer some questions about the passage. My goal is to have this survey available online, so people can complete it from their home, school, work, or etc . . . I would like to use forms that transmit the data to some type of database. I am not looking for anything fancy, just something that works and is inexpensive. Listed below are the tools that I have as well as the needs for this project. I should add that I am comfortable with making MS Access databases and html forms in FrontPage. So, I would like to use them if it is possible. I will be doing my stat's on SAS and SPSS. I appreciate any advice that you can give to me.

Tools that I have:
MS Frontpage and Access on XP Machine
StarOffice
Webspace with Subdomains, MySQL 3.23.x, and FrontPage Server Extensions.
Computer with Mandrake Linux and Windows XP

Needs of my system:
Each user will have to log in with a userid and password that I give to them.
database will record the userid of the person completing the forms and the date and time that they complet the forms.

That's about it!

Thanks!
 
You'll need to use some sort of server side script. Find out what server side scripting language the web server supports. If they have MySQL available, they should have PHP as well.. they usually go hand in hand. It's really simple to do what you need with PHP/MySQL.
 
I'd go with what KT said. PHP is a fairly simple language to use, and allows you to easily read data passed from a form, and also to connect to MySQL databases.
 
Thanks for the input guys. I am a real beginner when it comes to this stuff though. I know how to use MSAccess pretty well. Is creating a MySQL database similar, and what software do I use to make an SQL database? If you can direct me to some links, I would appreciate it. I really have no idea where to start. Yes, my server does have PHP.
Thanks Again.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top