Best I could tell, the proper way to proceed was to use the Software Center to uninstall version 3. Then I found this article on installing LibreOffice 4.1 from the PPA. After installing with
sudo apt-get install libreoffice
, I tried out LibreOffice Base.I created a new database and tried to open it. Uh-oh, I got this error:
The connection to the data source "SampleDatabase" could not be established.
and
The driver class 'org.hsqldb.jdbcDriver' could not be loaded.
Now what to do? I went back into the Software Center and looked at LibreOffice Base and there were several optional add-ons for a variety of database drivers. Select every one available and updated. Nope, still not working.
Somehow installing from the PPA is not linking correctly so the hsqldb.jdbcDriver can be found. Doing some more research I found another reference to exactly just that topic on the LibreOffice forum: Upgraded to LO 4.1.0.4 now get 'connection to data source' error
Reading through that showed me how to install that specific driver with this:
sudo apt-get install libhsqldb-java
(Side note: I did not need to remove the old symbolic link and create a new one as mentioned in the post by dtmonterrey).
Bingo! LibreOffice Base now opens my new database and I can connect to create and edit tables.