I work for a state agency which consists many file servers depending on an individual's location. Although all staff have access to all file servers if they know the path and how to map to it, each person is usually assigned to a specific server.
A database was recently created that IT staff would use in updating computer equipment during a refresh. The database was successfully split and the front ends were placed in regional folders for IT staff to access. When staff assigned to a different file server than what this one is located on tried to access the front end, they received an error message stating the path was not found. They were however able to open the back end successfully which is on the same file server as the front end.
My question: Is this lack of access to the FE because their assigned file server is different than the file server the database is located on? If so, is there any sort of work around on this issue or setting modifications that can be made within access?