Thanks to everyone who replied to my questions about Macintosh Access (a lot of folks did!).
I have 4 or 5 products to look into - which sure makes me feel a lot more positive about finding a good solution.
I'll post a summary of which product we settled on and why sometime in the furture.
Thanks again for the great responses!
Graham