Hi Richard!

Thanks for the thorough seminar. I've checked several forums and in general people don't recommend copying the backend database to a shared folder on a NAS server. I've just learned that Synology can manage mySQL. Could it be an appropriate solution for a small company (with 5 client computers in various locations) to use the Synology server as SQL server.

Thanks For your help!

Gergely

---

Reply from Richard Rost:

I don't generally recommend an Access-only solution like this for high-traffic databases. However, I've successfully set up 20- and even 50-user databases with JUST split Access databases, so it depends on the thruput and network speed.

I've never used Synology, so I cannot comment on their product. However, I recommend you take a look at SQL SERVER EXPRESS. It's a free version of Microsoft's powerhouse SQL Server database, and it's a GREAT back-end solution. The Express edition is FREE and handles most small- and mid-sized business needs.