I have a web application that uses Redhat/Apache/PHP/Mysql to create a searchable database for a CCG game. There was a VB executable application that did similar functionality that ran off of an Access (mdb) database. The developer of the VB doesn't plan to do future updates, so I started to think about creating scripts that would generate the mdb file needed from the Mysql database that I use (the data is similar but stored much differently).

I can access the tables of the mdb file, so I know how to conceptually convert one to the other, but I can't seem to find any any way for PHP to generate, much less import into, an mdb file on linux. I don't have easy access to an IIS machine, cause it seems that I can do it there using the COM libraries.

Does anyone have any tips or leads to offer on how to make this
conversion happen? I was hoping it could be done with a 'realtime' script as my database is updated frequently. Any help would be appreciated :-)

Ethan Burrow
saark5@yahoo.com

    Have you tried MyODBC. You can connect to MySQL via the ODBC driver, generate a MDB with linked tables then move data with a simple copy paste or a script at most.

    Saludos
    Gerardo

      If it were a one time conversion, I could probably do it that way. However I'd like for a user to be able to click a button on a webpage and download a current mdb from the current data in mysql. Thus the entire process would ideally be scripted with no human intervention. All on a linux server box.

      Is this possible?

        Write a Reply...