I'm looking for some direction from you who would have some better viewpoint and experience as to the best way to accomplish my project.
What I would like to accomplish is to have a client/field office update/add/edit database records located on a server, ala, via the internet. I was thinking that setting a secure vpn would be more difficult in the end, but perhaps not. A simple app which as far as it know is accessing a table on a mapped drive. But then I thought I would investigate the other alternative (web app/service) before getting too committed in one direction. Any comments would be very welcome. Thanks