K
karen scheu via AccessMonster.com
I have an application that contains a master table of orders that is read
only access for all users. Currently I rebuild the table with 4 years of
data. I need to start a daily update of the orders table. I will import a
table from AS400 that is same structure as my master orders table in access.
What is the best way to update the master table. I originally thought to run
a make table query that selects only unmatched orders, then simply append
this table to my master, and also run an update query that will update the
entire row if a match is found.
Is there a better way to do this using access basic. I would like to keep a
log of the updated key fields. Can anyone give me some ideas as to how to do
all this?
Thanks,
Karen
only access for all users. Currently I rebuild the table with 4 years of
data. I need to start a daily update of the orders table. I will import a
table from AS400 that is same structure as my master orders table in access.
What is the best way to update the master table. I originally thought to run
a make table query that selects only unmatched orders, then simply append
this table to my master, and also run an update query that will update the
entire row if a match is found.
Is there a better way to do this using access basic. I would like to keep a
log of the updated key fields. Can anyone give me some ideas as to how to do
all this?
Thanks,
Karen