Hi, I'm running a Linux server with PHP+MySQL installed and I'm writing a script that should gather some data from the user, store them into the MySQL database and then it should let the user download some results in the form of an Acess' .mdb file.

Does anybody know of a way how to do this?

Any suggestions will be appreciated...

Thank you.

    Why access?

    An empty access dbase containing a single dbase is almost entirely useless.

    I would output a CSV text file - this could be imported into anything: Access, Excel, OOffice etc.

      Thanks for reply ..

      Well, the output of my script should be an .mdb file because it will be used for further processing by another company, which demanded me to use that format.

      Otherwise, I would of course prefer a another solution, such as the one you suggested.

        2 options that I can think of

        ODBC
        PEAR

        Now I'm pretty sure that you will not be able to create an mdb from scratch so you will need to have one already in existance to receive the data. Simply empty the table before adding your new data. The user will then be able to download a copy.

          I'm not sure, but wouldn't these two options require me to have an access to some MS-SQL server?

          Which I don't have.

            No. Read the user notes on odbc_connect, odbc_execute etc for more info. PEAR database abstraction is specifically non-specific: ie not tied to any platform or engine, that is why it is ABSTRACTION.

              Write a Reply...