Multiple-user Access file issue with switching to Synology NAS server from Windows 2003 Server
Posted on 2014-11-19
I am not familiar with Microsoft Access, however we have a customer who upgraded from Windows Server 2003. All his business files were stored on that server and are now copied to the new NAS server. One of these files is a Access file (rolodex.mdb) which we are having issues with. Multiple users are mapped to this NAS server and 4 of these users need simultaneous to the Access file. Simultaneous access to this file was no problem under Windows. Now under the NAS device only one user can open the file by clicking on the shortcut/file which opens fine. If that file is open on the network and another user tries to open it nothing opens (no error messages, no event log files, nothing) it just acts like your clicking in empty space. A workaround (which the customer says is unacceptable) is to open Access on subsequent computers that need to open the file and open the rolodex.mdb file from within Access.
Most everything on the network is working fine at this point.
My questions is can we fix this so all 4 users can access this Access file by just executing the shortcut AND are there any other potential problems in accessing this file from the Linux NAS server (would Windows be better)? They don't want to go back to Windows server so we really need to make this work safely if possible.