LibreOffice Base to View Access DB

This is a summary of a post found on askubuntu.com.  Useful for opening up an acquired accdb file on Debian/Ubuntu.

One-time setup:

1. Make sure LibreOffice Base is installed – sudo apt-get install libreoffice-base
2. Download UCanAccess and extract it – http://ucanaccess.sourceforge.net/site.html
3. Launch LibreOffice (not Base, just the main launcher)
4. Tools > Options > Advanced > Class Path
5. Add Archive: /root/Downloads/UCanAccess-3.0.7-bin/loader/ucanload.jar
6. Close LibreOffice Launcher

Per-Database setup:

1. Launch Base
2. Connect to an existing DB (JDBC)
3. Datasource URL – jdbc:ucanaccess:///path/to/.accdb/file
4. JDBC driver class – net.ucanaccess.jdbc.UcanloadDriver
5. Next, leave blank
6. Finish/Save