If you don't want to use web technologies then you will have to use networking technologies. I would look into setting up a VPN or using Terminal Services. I know enough to know that these technologies exist, but I have never had to set them up.
If you want to share your database via a browser front end (the web) you're in the wrong place. You need a web base front end for which you can use Active Server Pages (.asp), PHP (er .php) or .net (Spawn of Satan) each of which is capable of connecting to your database on the server and allowing miltiple users to access it. ASP might be the easiest be in this respect as the language is slightly simlar to vba.
It sounds, thought like you want to share across a network. To do this split your database into a front end (Forms, Reports, queries etc) and a back end (tables).
Put the back end on the main server and copies of the front end onto the other machines. Link the tables from the front end to the back end (in the menu get external data > link tables).
That's putting it very simply and missing out a few steps, but it's basically the way to go.