So you read passages about Open Office 2 and such but that is NOT Microsoft Access which some are hogtied to.
I'm not going to ask you one question but share a solution.
http://en.wikipedia.org/wiki/Citrix_Presentation_Server
Bingo. Now armed with your Citrix server on your network you can run Access on that and all the stuff will work just as you wanted.
Bob

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic