How do you access a database from a HTML webpage?

Question

I have designed a website in Dreamweaver and I have a Database with tables and reports etc. done within Microsoft Access. How can I link a box on the website to a list box in the Database to show information on the webpage from the Database

Answer 1

You can't do this directly. You need some for of server side scripting environment.

The specifics would depend on the environment you use, e.g. in Perl you could use:

CGI to get the server talking to your code:
http://users.easystreet.com/ovid/cgi_course/index.html

DBD::ODBC to talk to Access from Perl
http://search.cpan.org/~jurl/DBD-ODBC-1.13/ODBC.pm

Template-Toolkit to output your data:
http://template-toolkit.org/

Answer 2

It's a little more complicated than that just linking. I recommend reading up on PHP and mySQL.