updating tables

[Guest]

I create a table for production management in Access from multiple databases
in our operating software. Then make additions in the production table like
machine assignements. How do I get the production table to automatically
update changes made in the original databases, eg changes in ship date,
quantity but not lose the data I have added. Right now I am making manual
changes.

 

[Larry Linson]

I create a table for production manage-
ment in Access from multiple databases
in our operating software. Then make
additions in the production table like
machine assignements. How do I get
the production table to automatically
update changes made in the original
databases, eg changes in ship date,
quantity but not lose the data I have added.
Right now I am making manual changes.

Other than to caution "you do it very carefully", it is not possible to be
very specific without details on the "multiple databases in our operating
software" and your "production management" table.

In general: You can link tables in other Access databases, and some other
databases as well, so that you use the data directly from the original
database. If that's not possible, you can temporarily link the tables and
use them to update tables in your database via update or append queries, or
you can write VBA code to process them.

Larry Linson
Microsoft Access MVP