Updating tables

[Guest]

We maintain a table (table A) of names and addresses in Access 2003. We
periodically recieve a table (Table B) of names and addresses from an outside
source. We would like to compare the two tables in a form and indicate if A
should be updated with B information, then update, or if B should be
appended to A, then append.

 

[Guest]

You might want to look into using Total Access Detective from FMS to handle
this:

http://www.fmsinc.com/products/detective/index.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________