Base is a full-featured desktop database front end designed for non technical users. LibreOffice is a powerful, Free and Open Source office suite. But I still know some who like to use LibreOffice Base. For most I suggest using DB Browser for SQLite (DB4S) project which has a great UI, is open source and cross-platform. Most of my personal projects use SQLite as the database. Thanks Gord Thompson, you helped me a lot.I love SQLIte for its simplicity, portability and stability. When the wizard completed it opened my LibreOffice database and I could see the tables in the. In Step 4, I saved the LibreOffice Base database as “accdbTest.odb” in my Documents folder. In Step 3, I left the “User name” field empty and just clicked “Next >”. The Access file I wanted to manipulate was named “baseTest.accdb” in my Downloads folder, so in Step 2 the “Datasource URL” was jdbc:ucanaccess:///home/abrar/Downloads/baseTest.accdbĪnd the “JDBC driver class” was Then I launched LibreOffice Base, and in Step 1 of the wizard I chose “Connect to an existing database (JDBC)” Note that you must close and re-open LibreOffice for the new Class Path values to take effect. home/abrar/Downloads/UCanAccess-2.0.9.5-bin/lib/hsqldb.jar home/abrar/Downloads/UCanAccess-2.0.9.5-bin/lib/commons-logging-1.1.1.jar home/abrar/Downloads/UCanAccess-2.0.9.5-bin/lib/commons-lang-2.6.jar On the Advanced tab I clicked the “Class Path…” buttonĪnd then added the following five (5) JAR files using the “Add Archive…” button: /home/abrar/Downloads/UCanAccess-2.0.9.5-bin/ucanaccess-2.0.9.5.jar I launched LibreOffice (not Base, just LibreOffice itself) Then I downloaded UCanAccess to my Downloads folder and unzipped it. Here’s how I did it on a clean install of Ubuntu 14.04 LTS.įirst, I installed LibreOffice Base itself sudo apt-get install libreoffice-base We can use the UCanAccess JDBC driver to connect to Access databases (.mdb and.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |