I'm looking into moving it to an internet database format. We have two separate locations, but they share the same resources, hence the need to share a database.
Has anyone had any experience with something like this?
Our system used to be like this, but it could be a slow process for all the satellite offices.
What we have now is, every office has it's own database, which is a replication of the main one.
if I change something here, it updates our database here and pushes it our to the other offices in real time, but as it's a local database, if the internet connection happens to be running slow, it doesn't slow us down, it just works in it's own time, updating till it's done.
The neat thing is, if a project is assigned to a satellite office, the data for that project is stored in the local office database, we can't change any of the project details, but we can add documents, change drawings etc, so each office manages it's own project database, but share the contact and project information etc.