In the past I have always setup my Rooms
And Resources database on a single central database, regardless of the
number of offices and users that would be using the system. It always worked
well until my last place of employment where different offices started
having different requests for access to the database, and requests where
they wanted to make sure that staff from one office couldn’t go into the
database and see/edit bookings for another office. In the end it
just got all messy and since then I’ve changed my outlook on Rooms And
Resources databases and now prefer to have seperate database at each location.
So I was wondering How Do YOU do it?
How many locations and staff do you support and how do you setup
the rooms and resources database, as a single central database or as seperate
databases at each site and is there a specific reason for doing it the
way you do?