Open View MS Access mdb files in Ubuntu Linux

By | July 30, 2020

MDB Tools

MDB Tools is a set of utilities that can be used to read mdb format (Microsoft Access) database files on Linux.

It also comes with a gtk based graphical frontend tool called Gmdb (Gnome MDB Viewer) that can be used to read the table structure and data quickly and easily.

More information can be found at the project website http://mdbtools.sourceforge.net/.

On Ubuntu or Linux Mint it can be installed from synaptic -

$ sudo apt-get install mdbtools-gmdb

Then launch with the following command

$ gmdb2
About Silver Moon

A Tech Enthusiast, Blogger, Linux Fan and a Software Developer. Writes about Computer hardware, Linux and Open Source software and coding in Python, Php and Javascript. He can be reached at [email protected].

One thought on “Open View MS Access mdb files in Ubuntu Linux

  1. MurliGawali

    Sir,
    After installing
    $sudo apt-get install mdbtools-gmdb

    the MDBTools is not working Showing
    “could not find driver ”

    here is my php code —>
    $database=”/opt/lampp/elibdata/database1.mdb”;
    $driver = “MDBTools”;
    try {
    //$dbh = new PDO(“odbc:DSN=MS Access Database;DBq=$database;”);
    $dbh = new PDO(“MDBTools:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBq=$database;”);
    //$dbh = new PDO(“pgsql:host=localhost;dbname=”,$database,””,””);
    //$dbh = new PDO(“odbc:Driver=$driver;DBQ=$database”, “”, “”);
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = “SELECT * FROM Admc”;
    $STH = $dbh->query($sql);
    $STH->setFetchMode(PDO::FETCH_ASSOC);
    }
    catch(PDOException $e) {
    echo $e->getMessage().”n”;
    exit;
    }
    #close the connection
    $dbh = null;

    Please guide me in this matter.

    Thankx in Advance.
    MNG

Leave a Reply

Your email address will not be published. Required fields are marked *