Well, access is just a front end. You need a back end that access and apache can both interact with. This is what mySQL is for (ODBC). For implemeting the SQL interaction with your web server I would recommend PHP.
But really it depends on what you are trying to do. If your data quest is simplistic perhaps just exporting to a csv file from access and using a simple bash script to format you data into whatever-you-want for the web server may be a better way to go that integrating SQL and PHP. It would depend on the amount of data and how often that data is updated/changed and exactly how you need this data to interact with your web server.
|