How to update table_A only with new records from table_B

[qb828]

How to update table_A only with new records from table_B

Hi I have One database(let's call it "master" and one copy of it ("slave&quot.
As I enter data into the slave database, I need to update the master database with only new records.
They are basically same database( cotaining same tables).

How can I update only new records from the slave to the master database??

This shouldn't be too hard. I am sure this kinds of transactions are done a lot.

Can you help me??

Can this be done in MS access ?? or do i need to write some sql stuffs??
thanks you

ex)
master DB
----------
table A
name
address


slave DB
---------
table A_slave
name
address

QB

 

[alr0]

Hi QB

This is not a standard thing to do regularly so you should probably look carefully at your design and why this is necessary.

A simple way is to link the slave table to the master mdb and use the unmatched query wizard.

The result will be all the records that exist in the slave but not the master. This can then be converted to an append query to add those records to the master.

Hope this helps,

alr

 

[JonFer]

MS Access 97/2000 supports replication but you should look carefully at the impacts before making your database replicable. Microsoft has several articles in their knowledge base.

 

[nberryman]

I must agree with both of the above, WHY do you want to do this?

And avoid Replication like the plague



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[jkmitchell]

Hi qb828,

Did you find a solution to this?

We have a similar problem, a central database and then "sub-copies" (based on the clients belonging to the salesman) on laptops across the world, literally.

The idea is that the salesmens databases are emailed back to base on a periodic basis and the master is updated with any changed details (clients address, phone for example). Once the master is updated we will then send a new copy to the salesman

So far so good but we are stuck on the update of the Master Database, hence my question.

Cheers

John