I have developed a database using MS Access 2013. The back end resides on a local network drive (NAS), and the front end is installed on everyone's PCs (the number of users is small, only 4 people). It works fine and is really useful. However, it would be even more useful if it could be accessed remotely. I can access files on the NAS via the internet using a browser. So in effect, a (password-protected) URL for the folder in which the backend resides is available. It would be great if from a remote location I could get the frontend on the PC to link up with the backend in the office via the URL. I have tried playing around with various external data settings but no luck.
1) Is what I am attempting even possible ? If yes, any advice on the necessary settings would be greatly appreciated.
2) If the answer to 1) is "No", are there any solutions for remote access that involve leaving the backend in the office ? Call me old-fashioned, but if possible I would prefer to avoid putting sensitive data on an external server. Not my #1 choice, but if necessary I am willing to invest the time to learn how to set up and manage a server.