How to "use" an access database from a Web Page?
Posted on 2002-07-26
I don't know if my problem is related to ASP, HTML or some else kind of "web language". I will try to explain my problem, and you experts i hope will teach me the right way.
I've a Access Database with 3 tables:
1) tPerson is a table containing usual personal data (name, address, etc), with a ID number as key.
2) tQuestions is a BIIIIGGGG table fulfilled of "Medical" and "Nutritional" questions: some are in "yes/no" format ("Do you smoke?", "Have you the Haltzeimer?"), some are in "options" format ("How many cigarettes you smoke per day? <2 / 3 to 8 / 8 to 12 / >12"), and some are in "text" format ("Describe <<somewhat>>").
3) tAnswers is a "clone" of the tQuestions table, containing a reference ID to the person in tPerson, and the answers that person give.
My customer now want to "switch" from the usual MSAccess forms (that requires MSAccess installed) to a "HTML" interface. He don't needs to put the DB on the WEB, he only wants to have not MSAcces installed on every PC of every Doctor whitch use that DB.
I'm totally "OUT" about this kind of stuff...i can only build simple HTML pages...and the HTML pages exported fby MSAccess are pretty unreadable....so this is my question:
How can i build a "Simply maintenace" web page that can browse the tAnswers table, depending on the Person selected, and a Web page that can write/edit new data?