Updating two Access Tables at the Same Time - TechRepublic
Question
May 6, 2008 at 07:29 AM
castejb

Updating two Access Tables at the Same Time

by castejb . Updated 17 years, 9 months ago

I have two individual systems with their own databases running on our server.
Once system is for payment management and the other for customer control

I need that whenever a payment is entered and fields for
accountNumber,
date,
time,
and RepresentativeID
are completed them to be added as a new customer automatically in the other system. When the data is copied I need the remaining fields to be added in the customerControl program by code (automatically).

Field names are not the same in each program and Primary Keys for the tables are not the same.

Is there a way I can achieve that?

This discussion is locked

All Comments