Thanks for the advice Simon, After considering what both you and GalaxiomAtHome have suggested i think the server route might be the way to go.
Although creating a web application for the database sounds the best way in terms of ensuring everyone is using the most up to date forms, queries etc...