Moving from my old Qnap to a Synology NAS...

It was pretty simple acutally. The Synology management console is pretty easy to understand. You need to set up a new share, a new user for the FTP service and grant that user access to the share as well as access to the FTP service. The Synology web site has good clear documentation.

Installing and running MariaDb was trivial once I'd found it under Utilities. The myPHPAdmin works well. A bit wierd in places but ok once you get used to it.

I needed to download and install the ODBC driver for MariaDb and alter the code to look for the new connection to MariaDb

The only tricky bit was that I'm not using MariaDb 10 which does not allow Utf8 encoded characters in INSERT commands. In email these are used to encode emojis. I used the VBA regex replace function to strip them out (see function demoji(txt)).

If you are doing some changes it's a good idea to back all your old data before you start playing. Then once everything is working, clear out the table, import the old data and then you can start again from where you were.