How to Open View MS Access mdb files in Ubuntu / Linux

By | May 1, 2023

MDB Tools

MDB Tools is a set of command line 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:

On Ubuntu or Linux Mint it can be installed from default repositories:

$ sudo apt-get install mdbtools

If you want a gui tool then use MDB Tools Gmdb program from the following github project:

The package is not available in the ubuntu repositories, so you need to compile it for ubuntu or any other distro.


Earlier there was a package named mdbtools-gmdb that could install everything, but its no more available.

$ sudo apt-get install mdbtools-gmdb
$ 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 Comment

How to Open View MS Access mdb files in Ubuntu / Linux
  1. MurliGawali

    After installing
    $sudo apt-get install mdbtools-gmdb

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

    here is my php code —>
    $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”, “”, “”);

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

    Please guide me in this matter.

    Thankx in Advance.

Leave a Reply

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