Instructions

Upgrading...

If this is the first time using this database, please skip to Getting ready...

As with anything of this nature, backup your data before proceeding.

To upgrade from version 1.2 to version 1.3.2, extract the gun.odb file and overwrite your existing gun.odb file.

---

(Please note: If you've already upgraded from 1.2 to 1.3, you need not do anything more than overwrite the 1.3 version of gun.odb with the 1.3.2 version of gun.odb and change the Datasource URL.)

As when you first set up the database, you first have to change the Datasource URL as appropriate. Open gun.odb and go to Edit > Database > Properties: Screen 6

...and change ~/databases to the location of the gun.odb file and the gun folder: Screen 7

...and, if you're using Windows, change /gun/ to \gun\:

...and click OK, then File > Save.

(Please note: If you're upgrading from version 1.2, please proceed.)

To finish the upgrade process, open the UPGRADE form and click on the button you find there:

All done.

Getting ready...

This database requires LibreOffice (or OpenOffice + the Oracle Report Builder), a recent version of Java, and the HSQLDB 2.2.6 (or later) engine.

After downloading and installing LibreOffice (and Java, if necessary), download the hsqldb-2.2.x.zip archive (sourceforge.net) and extract its contents. Particularly, the file hsqldb.jar from /hsqldb-2.2.x/hsqldb/lib/ inside the zip archive. Put hsqldb.jar somewhere on your computer where it won't be moved or deleted. If you get an error message later on when trying to open/edit your database, use the latest hsqldb.jar snapshot.

Open LibreOffice, go to Tools > Options > LibreOffice > Java and make sure Use a Java runtime environment is checked, and a version is selected and highlighted.

Then click on Class Path > Add Archive and select the file hsqldb.jar.

It should look something like this: Java Screen

Click OK > OK and File > Exit LibreOffice. If the quickstarter is enabled in your tray area, exit that, too.

Now you can download and set up the database itself.

---

IMPORTANT: If you've been trying out an earlier version of the database, first export/backup your data.

Setting up the database...

First extract all files from the zip archive: Screen 1 Screen 2

Then copy the location of the gun.odb file and the gun folder: Screen 3 Screen 4

ABOUT THE MACROS: When you open the gun.odb file, you might get a warning about macros. You don't need to enable macros at this point, but if you want all the features to work, you can enable macros later (see below).

Then open gun.odb and go to Edit > Database > Properties: Screen 6

...and change ~/databases to the location of the gun.odb file and the gun folder: Screen 7

...and, if you're using Windows, change /gun/ to \gun\:

...and click OK, then File > Save.

ETA: Oh yeah... And click on Tables, wait for it to refresh and show the tables, then you can go back to Forms and open that to enter gun records. Not sure why it won't refresh automatically, but it doesn't, at least not for me: Screen 9

"Registering" the database...

You must also "register" the database. This does NOT mean information is sent anywhere. This just means that LibreOffice keeps a list/registry of databases, and in order for all the features of this database to work properly, it needs to be on the list. Basically, go to Tools > Options > LibreOffice Base > Databases > New > Browse > Open your gun.odb and save the settings. The registered name must be gun.

IMPORTANT: If you were using an older version of the database and already exported your data, now is the time to import/restore your data.

Enabling macros...

To enable the macros to take advantage of the "accessories" features and automatic, periodic backups for this database, click on...
1 - Tools > Options > Security
2 - Macro Security >
3 - Trusted Sources > Add >
4 - Browse to the directory that contains your gun.odb file and gun folder (in my case, this directory is db in my home folder), and click OK > OK > OK then File > Exit (also exit the quick starter your system tray, if it's enabled): Macro Screen Shot

Changing the Backup Settings...

Open the BAK form, and change the settings to fit your needs. BAK form

The backup interval should be entered as a whole number specifying the number of hours that must elapse before another backup is made.

Click on the Select Folder button to pick the location where backups are to be saved.

When you have changed the setting to suit your needs, save the settings.