We need to be able to gain access (read/write), from our website running on a Windows Server (or it can be easily switched to Linux), to an MS Access 2007 Database which is on a remote server running under Windows Server 2003. We have been trying to do this using PHP and we had been under the impression that we could do this with odbc php functions (odbc-connect(), etc.), but have not been able to get this to work.
Note that the solution must use PHP, since we are familiar with it, and it needs to be able to read/write securely.
Also note that it is NOT an option to use a different DB than MS Access since it is part of the main software package we use to run our business.
Please include the word "serious" in your response so that we know that you can read and follow directions.