Linux Mint (Ubuntu) Microsoft Access Replacement?

Question

I've just switched over from Window to Linux Mint, and the only thing I'm missing is a replacement for Microsoft Access.

I'm aware of LibreOffice (which comes installed), are there any others I should look at? Any better? or any that can import an accdb?

Answer 1

I would go with QT and SQLite.

SQLite is very simple database. All data are in single file. The QT is a toolkit for creating application in C++. There is a nice IDE (for creating GUI) too, QTCreator. The combination could be an overkill for small projects, though.

It should be in official repository.

As of importing MS Access files. It is very hard. Even Microsoft has problems with converting old version of database files to newer formats.

Answer 2

See here: https://stackoverflow.com/questions/29044/good-free-alternative-to-ms-access

The short answer is that in terms of UI, form creation, compatibility with .accdb, etc. there isn't really anything solid that's comparable to MS Access in the Linux world.

Answer 3

I would take a look at Kexi. Kexi is an open source visual database applications creator, a long-awaited competitor for programs like MS Access or Filemaker.

^{Importing Northwind sample Microsoft Access (.mdb) database using Kexi on Linux}