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
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:
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