On Wed, Dec 14, 2011 at 3:21 PM, Ron Young ronyoung@nc.rr.com wrote:
@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business.
Does anyone have experience doing so?
I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x.
Is there another way to get read and write access to the mdb file from apache/php running from the linux box? A couple of hours of googling last night has resulted in finding very expensive odbc drivers for the linux box and nothing really foss except the odbc driver managers.
The best approach to doing this is to convert the access tables to use a sql server instead of the native mdb. This may or may not be practical/easy, but access can work over ODBC with the db on linux/postgresql (among others) where you would have a matching php client. Next best would be to write something to give web server access to the data you need on the windows box, and access it remote via http.