[AccessD] Update Query?

I also had a similar need a few years ago.  To suit my purposes, I picked up
a copy of FMS's "Total Access Detective"
http://www.fmsinc.com/products/detective/.  It allows you to compare two
database objects and determine what was added, modified, or deleted.
However this approach might have required that the two objects be
structurally identical...I can't recall.



Mark


-----Original Message-----
From: Bridget Doran [mailto:bridgetd at biostat.umn.edu] 
Sent: Wednesday, June 02, 2004 12:23 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Update Query? 


Hi all,

I will be pulling  a table on a monthly basis from another access
database. Initially, I make a new table with these records. Then monthly,
I want to update the new table with only records that have changed from
their original source or new records that have been added.

Is this a simple query?

Thanks for any help.

Bridget Doran


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com