33

I have an MDB document that I need to view on my Ubuntu machine, I downloaded MDB viewer and when opening the file with it the application closes. Also OpenOffice DB viewer does not want to work.

Are there any other applications that I can use?

Jonik
  • 5,940
Elitmiar
  • 3,272

6 Answers6

23

I think you'd better install the mdbtools-gmdb (http://packages.ubuntu.com/trusty/mdbtools-gmdb) through Ubuntu package manager, otherwise there are no guarantees that the package is binary compatible. (Lots of distros use .deb)

DavidPostill
  • 162,382
EFraim
  • 555
20

Re: Installing mdbtools, line should be:

sudo apt-get install mdbtools-gmdb

That's why you go the 'Invalid operation...' error.

(can't comment yet, hence the separate answer)

Tim Lytle
  • 1,009
8

You can use DBeaver. It has "MS Access (UCanAccess)" driver to open .mdb files.

To install:

wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb
sudo dpkg -i dbeaver-ce_latest_amd64.deb
sudo apt install -f

Then connect to the .mdb file:

screenshot

Tested on version 21.0.0

Pablo A
  • 1,733
fakePlayer
  • 139
4

On Ubuntu 18.04 I tried installing mdbtools-gmdb but it couldn't find the package. I ended up installing mdbtools with apt install mdbtools.

This package provides libraries to connect to mdb files as well as command line utilities including mdb-tables, mdb-export, mdb-sql, etc.

kjpc-tech
  • 321
1

If you only want to view or export the contained data you also could use an online viewer/exporter like www.mdbopener.com.

mdbopener.com is using the mdbtools for .mdb files and the jackcess library (java) for .accdb files. Disclosure: I am the creator of www.mdbopener.com

Sarah Reinhardt
  • 11
0

There is a cloud version of MS Access available. (http://www.apponfly.com/en/micro...)

They provide 30day free trial via remote desktop connection.

davidcondrey
  • 1,748