Do all 3 computers have Access installed?
You should split the application in to |Front End and back End, each user should have their own copy of the front end stored locally on their machine. This links to the back end on the network where all data is stored.