Since the main server db is production data, I'd suggest that a DEE (Decision Enabling Environment) database be created. This would be a nightly backup from production data, and all Access fe connections be based on this copy with read only access. I'm surprised you were given such access to production data. It would be VERY easy for this to be severely compromised by access to it via Access, so I have to suspect that the IT person(s) who gave such access don't know Access very well.
If you're looking for 5 state access to a centralized data source, Citrix or a Terminal Services platform might be the way to go but each user fe would have to be placed on a Citrix or Terminal Services server located in the same ethernet domain as the source data. Access over wifi is a sure recipe for disaster. Sharing a be over cloud services such as OneDrive is no good either (where the be is on the cloud and users are trying to access the same be). My meager experience with Citrix is working in Access from home, but the database was not local to me. Citrix would provide remote access to be and fe databases located on the same server or ethernet.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.