If you want to make a client/server type of database using Access as the front and back end, then put the back end (tables) on the server, and put a copy of the front end on each users' machine. Make sure they are all mapped to the network drive the same way.
For example, all PCs should see the back end at the same mappng, like "F:\Database\YourBackEnd_be.mdb"
All computers may be able to see it as different mappings, but this will not work, for example if one user sees it as above, and another sees it as "G:\Users\Database\YourBackEnd_be.mdb"
So where ever you develop the database, you need to make sure all computers are mapped the same way when you split the database, using the database splitter.