Updating an ACCESS 2000 file?

[THOMASNG]

I am using VB6 with ACCESS 2000.
With only ACCESS 2000, I am defining a complete listing
(table) of all the containers currently in a seaport.
However, using VB6, I am updating a PARTIAL list of the
containers, and storing this under a slightly different filename.

I would like to perform a merge ("mail-merge"?) of these two lists, letting the first listing exist (if the second listing has no update for the corresponding container), else preferring the second listing.
This way, the truck driver wouldn't have to update the
entire yard before updating the seaport's inventory.

 

[THOMASNG]

Solved it. Basically, I needed to save the ".mde" database under a different filename, then run two "simple select" queries to update the table.