Comparing tables in Access and showing in VB
Posted on 2000-04-12
Here is my delima. I currently have one table in Access that is a permanent table. I have a second table that is created once a month with new or updated records. Both of these tables have the same fields within them. What I would like to do is if there is an address change in the new table, I can compare the new table to the archive table and make the change to the address in the archive table. This new table would also include new records that would be appended to the archive table. Also, in my application I would like to be able to show the changed field with the text box in my application and show that text box as a highlighted box showing that there was a change. Please be specific. If you need more detail to answer this question, let me know. I'll do my best to explain. Thanks.