I launched LibreOffice (not Base, just LibreOffice itself) Note: When unzipping the distribution file be sure to specify "Keep directory structure" (or similar, depending on your unzip tool) so the folder structure appears as in the screenshot above. Then I downloaded UCanAccess ( bin.zip file) and unzipped it into the folder ~/Downloads/JDBC/UCanAccess One-Time Setupįirst, I installed LibreOffice Base sudo apt-get install libreoffice-base Here's how I did it on a clean install of Ubuntu 20.04 LTS.
We can use the UCanAccess JDBC driver to connect to Access databases (.mdb and.
Hopefully one of the alternative solutions above will work for you and get you into that ancient database of wonders that’s been previously locked away from prying eyes.Open Access database (accdb) ubuntu 20.04 Libreoffice Base It’s All About That (Data) BaseĪccess is no longer hidden behind a premium paywall in the way it used to be, but there are still plenty of people who don’t have access (no pun intended) to the software.
Given how popular Office 365 is these days, there’s bound to be someone within shouting distance who has Access installed on their computer, so it’s worth a shot at least. If someone sent you the MDB file via email, for example, you could ask them to resend it as a spreadsheet after converting it with their copy of the application. Specifically, it’s worth asking someone who does have Access to convert the file into a different format for you. Convert It With (Someone Else’s) AccessĬheekily, we’re going to suggest using Access again in an article about not using Access. It’s not a recommended method, but if nothing else works, it can’t hurt. However, the snippets of plain text contained within did provide clues as to what sort of database the file contained. With the MDB files we opened with Notepad, the majority of the content was a garbled mess.