By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Multiple copies of one .mdb file

P: n/a
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.

May 18 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

May 18 '07 #2

P: n/a
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.

May 19 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.