I have an Access DB and want to link a split backend from MySQL tables on a VPN. Before last week I had never seen/used MySQL but after several try’s I did manage to install MySQL, workbench and ODBC drivers locally on my Windows PC, then export the Access tables to it and re-Link SQL tables back to Access frontend . However when trying to install onto a VPN, the default location is C:\..... and I can see no option to change it. If I look at the Security Properties of the VPN, it says “root (Unix User\root)” so I am assuming the MySQL install should be a Unix version?
Can anyone help with simple steps on how to install on a VPN?
Thanks