Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    MS Access on UNIX?

    First of all, I personally don't think if MS Access database works on UNIX, but one of our client asked me to enable PHP's ODBC extension so that he could be able to run his Microsoft Access Database.

    He was referring to this URL:

    But states that ODBC extension is used to access Microsoft SQL Server Database, which would of course be running on a Windows Server.

    I would like to ask if someone had experience of using Access DB on UNIX and if you could clear this point?

    Thanks in advance.
    Muhammad Waseem
    Inspedium Corporation (Pvt) Ltd.
    InsPanel - Hosting Control Panel for Windows 2000/2003

  2. #2

    ODBC driver info

    I used to program MS Access. The ODBC driver does not let you
    put MS Access on UNIX. What it does it allow MS Access to talk
    to a regular UNIX database. So you run MS Access on your
    desktop machine and it talkes to the UNIX database on the UNIX

    The MS Access database is then referred to as the "front end"
    and the UNIX database is the "back end". You, in effect, use
    MS Access and do not have to be aware of the UNIX database
    on the UNIX machine.

    The ODBC stuff would be supplied by the UNIX database, not
    the MS Access database.

    Hope this helps.


  3. #3
    Join Date
    Oct 2002
    If you enable ODBC support in php, you can access Access database (which really is just mdb file) using mdbtools

    Bunch of linux desktop apps use that library and it alway provides "read only" access so I do not think there is much benefit to it other then parsing mdb file and dumping data in mysql or postgres database.

    If I am in the same situation as you are, I would be fair to my client and tell them that they will not be able to fully utilize Access database on linux and they should look for windows hosting.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts