Doesn't come out too difficult.
You create a 'master database' which holds all the tables and that resides on the 'server'. All users then have a set of forms and reports to access this table on their machine. This means that there is only the one set of data.
If you read up the help files on "database splitter", you'll see that it's fairly easy.