Update Tables

[KarenMike]

I use information that I obtain from a working file from a different system.
I am interested in updating the infomation on a regular basis, but I am being
told that a Make-Table Query will not work because I have relationships built
onto the parent table.

Here is an example, on a customer table, there are relationships with orders
and payments. Customers move, and usually, you can manually change the
address. In this particular case, I want to download the new information from
my other system and import it into my existing table.

Any suggestions?

 

[John W. Vinson]

I use information that I obtain from a working file from a different system.
I am interested in updating the infomation on a regular basis, but I am being
told that a Make-Table Query will not work because I have relationships built
onto the parent table.

Here is an example, on a customer table, there are relationships with orders
and payments. Customers move, and usually, you can manually change the
address. In this particular case, I want to download the new information from
my other system and import it into my existing table.

An alternative to repeated make-table queries is to run a Delete query with no
parameters, to delete all the records in your table; then an Append query to
fill it back up from the external source. This assumes that a) you in fact
want to completely REPLACE your entire table with the data from the external
source, and b) you have no links to child tables; such links would either
prevent the delete from running, or (if you have cascade delete set) delete
all your related data along with the new information.

You can use an Append Query based on a link to the source table, to append
only *new* records; but it can be a fair bit harder to *update* changed
records, especially if you have a large number of fields any one of which
might change.

John W. Vinson [MVP]