I can't change much about the general setup, but try to do the best working with it:
General Setup
A .mdb backend Microsoft Access, for VBA, is placed on a computer. Other computers access that backend, read and write. All computers are windows PCs
Past: Samba
All computers were in a workgroup. This does still work, but due to the troubles of getting workgroups to work on Windows and the changes that came over the years + the possible security implications, we thought about switching to NFS.
Also, I had some issues setting samba up on a Linux which is something I would like to do for various reasons. One being that I prefer configuring a samba server on Linux. Read more about that here: Setting up Linux Samba server (general problems): No permission
Future: NFS
A Linux computer provides the NFS server. All other computers are windows computers and NFS clients. The backend is shared, everyone can access.
I thought this wouldn't make a big difference access time wise, but it takes literally ages (10 seconds+) to access the data. Downloads take up to 1mb/s. Why is it so slow? We use NFS for other purposes (Linux to Linux) as well and it hasn't been that much of an issue there.
Is there some setting magic that allows us to improve this or is it just not a viable solution?
My current NFS configuration is:
/mnt/myshareddir 192.168.178.0/24(insecure,rw,sync,no_subtree_check)