how to connect html page with database(MS Access)?

Question

Hi..
may I know how I can store the values got from an HTML file into a database(MS Access). I need this to store marks of students in an online examination project.Please help...!

Answer 1

Learn ASP and ADO. It's not so hard.



http://www.w3schools.com/asp/default.asp

http://www.w3schools.com/ado/default.asp

Answer 2

W3schools Access Database

Answer 3

HTML is Hypertext Markup Language it is not a programming language. You will need to use a full programming language like PHP to add any logic to your pages and communicate with a database.



One other pretty major point you should research how many concurrent connections you can have on a Microsoft Access database. I think you sill find that you probably will want to go with a full fledged SQL database of you are going to stay with the proprietary Microsoft lines.



I would highly suggest checking out MySQL which is offered at most web hosting services usually for free with hosting accounts.

Answer 4

the othe answers are correct in that you need to learn a programming language like ASP, Php, ColdFusion or others, the reason is, HTML is a static document. Meaning the contents within HTML will not change. The code that HTML uses, or Tags (ie. Img Src, Center, A Href, etc.) are like making modifications in MS Word or other Word processing packages. In order to link to a database file where the content being dispalyed on the web changes (dynamic) you need a scripting language, which is what ASP, PhP and the others are.



If this is for a business and you would like assistance, I am currentl in between projects and would be willing to take a look at your needs requirements and give you an estimate as to how long and how much it would take to complete the project. If this is for fun, then you may want to consider other avenues of seeking help, as I've only bee in Yahoo Answers for a short time, but it doesn't look like it is designed for in depth help, you may want to try

http://tech.groups.yahoo.com/group/active-server-pages/

or

http://tech.dir.groups.yahoo.com/group/PHP_MySQL_usergroup/



Personally, I prefer ASP, but that is probably just because I learned on that language.



I'm assuming that you know you will need a web hosting service, unless you are running your own server, and depending on your host, you may be restricted you using 1 technology over the other. You may not be able to use ASP.



One thing I like about www.godaddy.com, which is the host I use, is that they have both technologies and they charge about $5 (or less) per month, which allows me to have an account for both technologies. Also, they have a lot of pre-designed site templates, like pre-designed blog sites, community sites like Yahoo Answers and the like.

Answer 5

Hi,

Accessing the databases from the HTML requires some Web programming.There are several languages available for this ,PHP,ASP.Net,JSP,etc.

ASP.NET is the most productive of all.You may use the ADO.Net classes for this available for accessing MS Assess.And storing ,manipulating and deleting the data.

Any futher clarifications you please let me know.



Best Wishes

Answer 6

There is a single but variable way to this. You have to a learn web based programming language like ASP, Cold Fusion, or PHP, etc.



ASP looks like the easiest one to learn in short term.

Answer 7

You can import java.sql. packages and should be able to connect to the odbc driver which can help you to connect to the database backend.As for webpage designing tool,try NVu by Mozilla.Its good with lots of features.

Answer 8

Can anyone tell what is the correct answer for this question?