Making a .html page to interact with an Access Database

[Dragenesis]

So I have an access database that I use to load xml documents and extract the info I want. I currently use a form to interact with the vba modules to accomplish the task. You check a box, push a button, and several queries are run against local databases to get all the necessary info, use it to load the xml documents, connect with Outlook, and generate e-mails. Can I instead use an html page to be the visual front end instead of an access form? If I can, how do I trigger the html page to find out what checkboxes are checked, and query the databases based upon them?

 

[HiTechCoach]

It is possible if you have a web server running IIS that can connect to the Access database. You will probably also need to have exchange server running to send the emails from the web server.

You can create a script, usually ASP (vbscript), to do all the processing like you have in your current VBA modules. It is possible to install and use PHP or some other scripting language. Your HTML page will need to have a form that "posts" to this script.

 

[Simon_MT]

You can use either ASP classic or .NET.

I could use either OLEDB and DAO or use XML extracted from Access. If you are already familar with xml this could easier. Either way use stylesheets.

css Stylesheets for typograhical formats
xsl Stylesheets for data interogation.

Simon