On May 18, 11:20 am, zjun...@gmail.com wrote:
I have built a DB in access that I use at work to track development
problems with a computer system we are acquiring. I have a problem in
that my boss insists on making a copy of the .mdb to take to meetings
etc. and make changes. Is there an easy way to merge his changes back
into the main mdb? So far I haven't made changes to it while he has a
copy offline, but I know I'm going to get bitten.
thanks for any help.
You could write some algorhythm to check fo rupdated records, or you
could add code to put some identifier (perhaps an asterisk) in an
unused field whenever your boss changes data and then just scan your
tables for the updated records based on that identifier.
If you buy the Developer edition you can use the Synchronizer, which
would allow you to copy the database to the server and the
Synchronizer will find all the records updated since the last
synchronization and update them fo ryou.