I used Base because I could easily design a simple form and flick between records. In retrospect I should have used MySQL and PHP from the start and coded all my forms in PHP. After several failed attempt the way which I found which worked was.
- Download WAMP server. Make sure you get a version which has MySQL 5.1, not the latest 5.5. You can simply download the latest WAMP if you wish, then click the icon in the system tray, choose 'MySQL' then 'Version', then get more.
- Check the WAMP is fired up and running the right version: click the icon in the system tray, choose 'MySQL' then 'Version', then 5.1.xx.
- Install a MySQL to ODBC connector which speaks to version 5.1 (here).
- Add a database to MySQL (however you wish, but the easy way is with phpMyAdmin from the WAMP system tray icon. Make sure you set up the access permissions for a user name.
- Add a connection to the database in the Data Sources list in the Windows Control Panel > Administrative Tools (more instructions here). The port number is probably 3306 if you haven't touched anything.
- Create a new database in LibreOffice Base which connects to the ODBC source by clicking File > New > Connect to an Existing Database > choose MySQL from the dropdown, then click Next. Choose 'Connect using ODBC' click Next, then browse for the data source you just added in Data Sources in step 5.
- Finally you can copy your table from your original LibreOffice Base file and paste it into the new file which is linked to MySQL via ODBC. You'll probably have to convert some data types along the way and rename some fields if the names are too long or use forbidden characters. LibreOffice will ask you about this if you need to do it.
Now on with the research!