syncing linked data between two access dbs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

We are using MS Access 2003. I've been asked to link two fields in our CS
database with two fields in our CA database in order to keep the data in the
CA db current. There are 468 records in the CS db and 4391 in the CA db. 111
of the records in CS do not have a match in CA. 4033 in CA do not have a
match in CS. 358 from CA have a matching record in CS and 357 in CS have a
matching record in CA. I'm not sure of the best way to proceed or if this is
even possible.
Anyone had a similar request and found a low maintenance automated way of
doing this?

Thanks in advance!
 
One approach would be to do away with the need for synchronizing altogether!
This may be a "political swamp", however.

If ALL of your records were in a single database/table, and each were
flagged as being appropriate for "CS" and/or appropriate for "CA" (if there
are only ever going to be two potential user groups, two checkboxes could
work), then your "CA" application would link to that table and use a query
to pull "CA" records, and "CS" records would be connected in an analogous
fashion.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yes, it would be nice if we could combine the dbs. If I cannot find a
solution without doing that I will pose that as a solution. However, I'm not
sure we want to give our users with access to CS db access to our other CA
db. I could always create user groups though and then make the groups limited
as to what they see when they open the db. That may be the way I have to do
this.

Thanks for your suggestion!
 
Back
Top