The Computer Oracle

Opening mdb files in Ubuntu

--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Puzzle Game 2

--

Chapters
00:00 Opening Mdb Files In Ubuntu
00:24 Answer 1 Score 2
00:37 Accepted Answer Score 23
00:52 Answer 3 Score 18
01:09 Answer 4 Score 6
01:32 Answer 5 Score 4
01:58 Answer 6 Score 1
02:20 Thank you

--

Full question
https://superuser.com/questions/34326/op...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#linux #ubuntu #softwarerec #microsoftaccess

#avk47



ANSWER 1

Score 2


A word-for-word translation under the original text is known as an interlinear translation.

John 1v1, from the Kingdom Interlinear

John 20v28, from the Kingdom Interlinear




ACCEPTED ANSWER

Score 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)




ANSWER 3

Score 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)




ANSWER 4

Score 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




ANSWER 5

Score 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.




ANSWER 6

Score 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