Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Updating two Access Tables at the Same Time

Locked

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?

Topic

Clarifications

In reply to Updating two Access Tables at the Same Time

Clarifications

I am sure

In reply to Updating two Access Tables at the Same Time

that there is a way to do what you are asking for, but I am equally sure you have a bad design. Why not put both tables in the same database and use consistent names?

I still need to get it Done. We have flaws

In reply to I am sure

I do understande design flaws however this two programs where developed in different Time Periods of the. For anybody to go threw a system changing process a lot of documentation and papers have to go threw and that will eventually lead to other things. I was looking for a easy fix that could be implemented with the current set-up that we have so I dont have to go into restructuring what are allready operational and Stand-Alone systems.

Linking Tables

In reply to I still need to get it Done. We have flaws

Try linking the one set of tables in the database that contains the other set of tables and editing them that way. You can create a function that will copy the contents of one field in table 1 to another field in table 2.

[Author]

Replies