Multiple copies of one .mdb file

[zjunkie@gmail.com]

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.

[ManningFan]

Re: Multiple copies of one .mdb file

On May 18, 11:20 am, zjun...@gmail.c om 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.

[Max Vit]

Re: Multiple copies of one .mdb file

Yes, this can be done using 'replication'; read the access help
regarding database replicas. I've used this in the past and it's
really good for the situation you're describing.

You need to keep a 'master' MDB and give your boss a 'replica' MDB -
then simply synchronise the 'replica' to the 'master' and you would
have what you're asking for.