I re-did my database in MS Access. The concept is the same as described for the LibreOffice database - a core of three tables : Site, Organism, Observation, with data entry forms. A starter version, setup with the taxonomic structure and organisms listed on the Macroinvertebrates.Org website, but empty site and observation tables, is available for download here.
Instructions for use:
You need an installed copy of MS Access I am using Access 2016, it may work with older versions.
Put the DB file in some folder, and create a folder called 'images' in the folder containing the DB file. Put another folder called 'Sites' in the 'images' folder.
Put a jpg image called 'error.jpg' in both the 'images' and 'Sites' folders, which will display when a broken image link is found. Also add a jpg called 'VideoMsg.jpg' in the images folder to display when a video file is selected.
The first time you open the DB file in Access you may get a security warning saying active content is disabled - this is because the DB uses macros and VBA code. It is safe - click the prompt to enable active content.
Access operates in two Document windows options - overlapping windows and tabbed documents. From Options on the File menu select Current Database and choose Overlapping Windows for the Document Windows Options.
When you open the DB file, select MainMenuF in the Forms group of Access Objects.
From there you can enter sites, observations and update the taxonomic tables.
Re. managing image sizes - the original size of most of my photos is in the 4-6 MB range. I use XNConvert to do batch resizing to limit the amount of disk space they use when associated with the database. By design, the DB application copies images from their original location to the 'images' and 'Sites' folder, which makes the images portable with the application, if you copy the images folders to a new location along with the application. XNConvert works very well in my experience and can easily reduce the space required for images by 90% without sacrificing quality.