I would create a new db and link the two tables that you want to merge but that part is optional. Then I would write a union query on the two tables which will automatically not include duplicates - see UNION query documentation in Access. This only works if the two tables have identical fields.... There are plenty of side considerations, but this might work for you.
Patrick > -----Original Message----- > From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 16, 2002 11:42 AM > To: CF-Community > Subject: Db merge question > > > I am not at my best today and am writing an app to merge 2 access > db's.... > I have the insert of new records covered, but am fuzzy on the best way > to check to see if a record in the old db is not in the new db, which > means that record needs to be deleted from the old db... > > What is the best way to do this? > TIA > > ~~ > Stephenie > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.401 / Virus Database: 226 - Release Date: 10/9/2002 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
