In this tutorial, I show you how to set up a split database version of the LibreOffice base database. LibreOffice (Open Office) Base Programming Book (affiliate) https://amzn.to/35wqtuI LibreOffice Base Split Database Example LibreOffice Base is a database management system that acts as a front end to the HSQLDB database engine. Within OpenOffice or LibreOffice split databases are much more reliable than the normal compressed variant of the database file. ☕ If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson ☕ Normally the database .odb file has the hsqldb compressed inside it and base automatically uncompresses the database to a temporary folder when it is being used and then recompresses the file on close. When you split the database it is still portable, and you can transfer it by copying the enclosing folder to other locations such as a USB stick or another drive and rename the odb file to create a copy of the database or a new one. The only disadvantage of the split database solution is that you will need to use SQL if you need to modify the structure of existing tables. You can use the base table designer to create your initial databases tables but to make modifications you need to use SQL. LibreOffice base as a front end to the hsqldb database engine is far from being a second rate alternative to access. In many ways, it is more powerful and can handle much more data. Get on the mailing list at https://www.businessprogrammer.com/create-libreoffice-base-split-database/?utm_source=YouTube&utm_medium=YouTube-Redirect&utm_campaign=Go-Link-on-video Video Production =============== Sony Camera: https://amzn.to/3mqyqfu Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum Microphones --------------- Screen Casting: https://amzn.to/3a2TnHN Microphone and Arm : https://amzn.to/3iwvL2S Talking To Camera: https://amzn.to/3FqXI6b Video Kit ------------- Lights Elgato video Lights: https://amzn.to/3sSK3xg Background Light: https://amzn.to/3uTXyPh Note Taking -------------- Rocketbook reusable notebook https://amzn.to/3sSK3xg #libreoffice #openoffice DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.