Unanswered: Accessing an Access Database from a web site
Hi. I have been given the task of figuring out the best way to allow information stored in an Access database to be displayed on the web. I have discussed using Java servlets and PHP to do it but they all lead to the same problem. Since everything is to be done on a Unix box acting as a server I do not know how to connect to the access database. Its easy enough on a Windows machine after you've set up the DSN name but drivers do not seem to be freely available for connections to Microsoft Access on Unix machines. I can only connect to databases created with MySql on the box I have right now. Would setting up a Windows server be better or is there someway to connect to an .mdb in Unix? Or maybe avoiding Access and just doing MySql is the answer. Thanks for the help.