Do you mean OneDrive? in the cloud?: YES
Not a good idea with an access backend, same as using access on a wan.
Also each user should have a local copy of the front end on their individual computer.
Are the 3 computers networked (Hard wired)?NO
You can put the backend on any of the 3 and connect the local copies of the front end to it.
Even better is to connect another computer to the network and put the backend on that as it needs to be on continuously.
Thanks for fast response. Will proceed with hard wiring all 3 computers.