Unanswered: Combining data from two database instances
I am the membership secretary for an association. I run an Access database for the membership details (name, address etc). I have a column for whether the individual has paid their subsription or not (Y/N). However I do not administer subscriptions. That is the responsibility of the Treasurer.
I want to give the Treasurer a copy of my database and allow him to update the column for individual members as and when they pay their subscriptions. I will not allow addition of new members or any other changes to be done.
I want to periodically take the Treasurer's copy of the database and update my 'master' database with the payment status. That is, update the column with any new Y's or N's. I will then reissue the database to the Treasurer to replace his old version.