update one record in two databases

[Guest]

We have two databases that are setup with linked tables on our server. The
first one holds one clients records (D-A). The second hold another clients
records (D-B). D-B has certian records that I would rather open and update
in D-A. Unfortunately, I cannot move the records from D-B to D-A because the
records need to be included in the reports done in D-B. I need a way to have
some of the records in D-B copied into D-A and to be able to update both.
Each record update updates other tables within its database. Both databases
were created from the same setup and are very simular. Is it possible to
copy the needed records from D-B into D-A, be able to update records in D-A,
and copy updates to D-B?

 

[John Vinson]

We have two databases that are setup with linked tables on our server. The
first one holds one clients records (D-A). The second hold another clients
records (D-B). D-B has certian records that I would rather open and update
in D-A. Unfortunately, I cannot move the records from D-B to D-A because the
records need to be included in the reports done in D-B. I need a way to have
some of the records in D-B copied into D-A and to be able to update both.
Each record update updates other tables within its database. Both databases
were created from the same setup and are very simular. Is it possible to
copy the needed records from D-B into D-A, be able to update records in D-A,
and copy updates to D-B?

This is a good example of why you should generally NOT have the same
data stored in two different places (whether the places are two tables
in a database, or two different databases).

Why not have all of the data in ONE database, with links to the data,
so that you only have one place to update?

It will require some careful and difficult-to-maintain VBA code to
update your redundant data. If I were offered a consulting contract to
write the code... I'd turn it down, and recommend restructuring the
data storage instead.

John W. Vinson[MVP]

 

[Guest]

LOCATE THE VERSION OF ACCESS UPGRADE

NOW SIMPLY USE THE TABLE DESIGNER AND CHANGE THE
RELASHIONSHIP TO MANY TO MANY