Hi Tom, We have this setup in Greater Manchester.
Recorder6 sits on a dedicated Windows server in the Council's data centre and we access it using the Recorder6 client application on our laptops once connected via VPN.
I would be interested to hear if others are finding this to be a workable solution. I wouldn't recommend this setup based upon our experience in Greater Manchester. Recorder6 frequently crashes and when it doesn't crash it takes ages to run reports, that's after I paid to increase my bandwidth (currently getting upwards of 40mbps).
I don't import data over the VPN ever as it seldom works. We are actually considering having a dedicated computer in the office for running the whole of Recorder6 (front and backend). This is a downgrade from having a client server setup but I'm hoping it will improve reliability and make the application more responsive. We have around 3m records. Shouldn't take 12 hours to run a report based upon a rucksac but it does. Yesterday I left Recorder6 creating a report for the EA from 11am. It finally crashed at 3am. I'm not sure if it's the council's VPN or Recorder6 (or both) but this setup is not working well for us at all. I'm having to rely upon spreadsheet snapshots more and more and manually merging files together to create an updated view.