Automatic Overwriting Records in Access 2007 With Updated Records from New File

[livtobeblessed]

Hi I have a database with many fields, and approximately 5,000 records. Each
month I have to provide an updated database to my mail vendor. Some fields
such as contact name, address, title and company name may have been updated.
Currently out of the 5,000 records I am using about only 1,000 of those
records as an active mail list. I have to compare use a unique identifier
to compare to the full mail list to build my updated mail list on. In order
to do this, I am manually appending over the 1,000 records because I cannot
tell what particular records have an update. Is there an easy way for me to
update the 1,000 records from the master of 5,000 by overwriting the 1,000
records from the 5,000 that carry the same unique identifier? I want to be
sure this becomes more of an automatic process than manual.

My second question is, within the same two lists, master update for appending
to mail list file, there may be some records that I'll need to delete because
that unique identifier is no longer existing in the larger file which mean a
firm has terminated and therefore falls off the mail list. How do I run an
update for deletions and would those records automatically be removed from my
mailing list?

Hopefully my inquiries is clear but if you need me to clarify anyting, please
ask and I'll try to clear up my question(s).

Thank you.

Gina

 

[Douglas J. Steele]

One approach would be to have a table that only contains the IDs of the 1000
active members. You'd then join that table to the master table of 5000
records so that only the matching records are returned by the query.

 

[livtobeblessed via AccessMonster.com]

Ahh! I see. I am so used to using the wizard and now I see what you mean.

I am still pretty fresh to Access because I just do not use it often enough
to know the tricks and so forth in Access, but I am trying to become more
accustom to it.

I'll try it that way and see if that solves my problem.

Thank you for your help.

Gina

One approach would be to have a table that only contains the IDs of the 1000
active members. You'd then join that table to the master table of 5000
records so that only the matching records are returned by the query.

Hi I have a database with many fields, and approximately 5,000 records.
Each

[quoted text clipped - 34 lines]

Gina