Does anyone know how to create an access database and use it to output static html files? For example, you have a html template and the field values for record 1 are dropped into this template. Field values for record 2 are dropped into the template again and thats the second html file etc.... Pretty much like a mail merge but with many html pages as the output.... Thank you
Please be more specific as to how you are doing, and what are the specifications of your web server. With Serverside Scripting it is possible. These types of scpriting languages include PHP, ASP, JSP, CGI, PERL etc. If your web server supports any of these and you either know how to program in them or you can arrange for someone to do it, it is very possible. But beware database access is very slow, which would not only make your websites lag but would create and over head for other database queries. MS Access alone can't do it but as I said with these languages it is possible for you to read a description of the record from a GET variable and then based on it display the results of the query. From my experience, I have done this, but with MySQL and PHP and not only was it a CMS but I also stored my images on the database. Alas I didn't use it for long because I could adopt other faster methods. Also if you just want to create pages using the database then again a language like PHP might be useful, and that I could do very easily on my own as well. Other than that you could use any language of your choice. Considering that Access tables can be converted to CSV tables, and any modern language can handle them easily, you can do it very easily. And then ofcourse, as far as I know PERL and PHP can read MS Access databases on their own. Going to be bery easy to do so. Just check out their documentations for the work you need to do.