How do I update data in a table when appending from another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a master database and want to append and update a table in the master
from a table in another database. Appending is no problem but if information
has been changed in the other database, I want it to update the information
in the Master table. I've tried the Update Query but I most be doing
something wrong because it's not displaying the updated information.

Anyone have any thoughts?
 
I usually use DAO to do this. Open two recordsets, one for each of your
tables. Start at the beginning of your new table and use the FindFirst (or
Seek) method to find the matching record in your old table. If it cannot
find a match, create a new record. If it does find a match, replace the old
information with the new information. Note: Seek is faster.

On my website (www.rogersaccesslibrary.com), are a number of small Access
database samples (mostly starting with "Update") which illustrate how to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top