Unfortunately you can not just place an Access database on a Web Server and use it through a web browser. If you have Access 2010 and a Sharepoint Server, you can publish your databses to a Sharpoint Server. This will convereted your database to ASP.net/JAVA/AJAX and Sharepoint lists. The downside is that your datasbe has to use embedded macrso and no VBA code.
If you place the back end on a web server, unfortunately you can not link to the tables from an Access front end over the internet.
I like to use a Thin Client Technology, like Terminal Server, that is connected through a VPN for the most add security. The advantages to using a Terminal Server is that the Application is installed locally on the Terminal Server. Installing updates to the Access front end is easy since it is local on the Terminal Server. On the remote client, ther is nothing that needs installed. The Remote Desktop Client is probably already installed with Windows.
There are other option for for remote access for your Access Application. List of some possible remote access solutions:
The best solution depends on several factors like the number of remote users and the experience level of the developer(s) in other platforms.
Using terminal Services, Citrix or some type of remote control requires additional hardware and possible software with little or no changes to the application. This means you can get up quickly with all the functionality of Access.
Using a SQL Server back end does require a server to run the SQL Server. This could be an in house server or “in the cloud”. This also will require developer time. How much time this will require depends on the experience level of the developer with SQL Server as a back end. This could take a month to server months to get working.
Using a Web front end does require a web server to host the web application. This could be an in house server or “in the cloud”. This also will require a lot of developer time to recreate the application. How much time this will require depends on the experience level of the developer with web applications. This can easily take six month to over a year to get working.
Also see this excellent discussion by Albert D. Kallal