32

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?

Improve this question
3
  • What MDB viewer have you downloaded? How was it packaged?
    – EFraim
    Commented Sep 2, 2009 at 14:24
  • .deb packaged, it's called MDB Viewer
    – Elitmiar
    Commented Sep 2, 2009 at 14:26
  • This question has zilch to do with Microsoft Access. You're not even using the Microsoft Jet/ACE database engine. The Access tag is not going to get you better answers on this, because the only people who will know the answer are those who use MDB files without Access.
    – David W. Fenton
    Commented Sep 25, 2009 at 0:17

6 Answers 6

Reset to default
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)

Improve this answer
9
  • Getting the Following Error, when trying to install mdbtools-gmdb Error: Dependency is not satisfiable: libgtk2.0-0 (>= 2.17.0)
    – Elitmiar
    Commented Sep 2, 2009 at 14:37
  • How are you doing the installation?
    – EFraim
    Commented Sep 2, 2009 at 14:40
  • 1
    Try sudo apt-get mdbtools-gmdb
    – EFraim
    Commented Sep 2, 2009 at 14:42
  • Gives me E: Invalid operation mdbtools-gmdb
    – Elitmiar
    Commented Sep 2, 2009 at 15:21
  • 3
    Oops, of course sudo apt-get install mdbtools-gmdb. Has been a long time since I had used Debian.
    – EFraim
    Commented Sep 2, 2009 at 17:27
18

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)

Improve this answer
4
  • Now you should be able to commment.
    – Macha
    Commented Sep 2, 2009 at 17:43
  • @Macha Only on my own, need 50 to comment. I'm not a power stackoverflow user, but I got enough rep to do stuff. I came over here and I can't do anything. :-) It'll just take some time...
    – Tim Lytle
    Commented Sep 2, 2009 at 18:40
  • @Tim Lytle: transfer your profile info from stackoverflow.com. This should give you some point boost!
    – EFraim
    Commented Sep 2, 2009 at 19:39
  • @EFraim - at the risk of getting in trouble for 'site' discussions: I have associated my stackoverflow profile with all the other sites, but that didn't change my points. Or did you just mean your upvote would give me some points? Thanks either way.
    – Tim Lytle
    Commented Sep 2, 2009 at 23:01
6

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

Improve this answer
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.

Improve this answer
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

Improve this answer
1
  • Still works in Apr. 2022, some 6.5 years later. Accepts a direct URL too, so no need to download and re-upload, at least for publicly-available files. Returns CSV and XLS.
    – AaronD
    Commented Apr 22, 2022 at 2:37
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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .