The macro-automation ensures seamless database access on any computer (Windows, OS X, Linux) while uniquely allowing these 'split databases' to be run along-side legacy 'embedded databases' as desired. This folder may be renamed or moved as desired, or distributed as a single zip-archive file. Likewise, a legacy ' embedded database' file may be converted to a 'split database' as necessary to avoid rampant data-corruption with Base.Ī split-database involves multiple files, but the template maintains everything within a dedicated folder for portability and backup purposes. Existing split-database users can add the macro (below) to enhance the portability of their own project. Key features include: a new database creation wizard drag-&-drop database portability seamless HSQLDB 2.3.x integration and a fix for the AutoValue setup bug in the Base GUI. The template combines a preset Base document (.odb) with the popular HSQLDB 2.x engine - collectively providing one of the most powerful and flexible, cross-platform, database options available for the desktop today. Simply download the template to an empty folder and open it in Base with macros enabled (or follow step-by-step instructions below). It serves as a replacement for the 'New database' wizard in Base.

OVERVIEW: This Base template (.odb) generates a ' split database' as necessary for proper data-durability and other considerations.

includes HSQLDB 2.3.2 ( User Guide 2.3.2.pdf / Utilities Guide.pdf )

Edit: Various versions will be posted here as development progresses.ĭownload: Split_HSQLDB_2.3.2_Wizard_v3d.odb.

Openoffice base templates