Exporting only updated record data

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

Guest

I maintain a db that contains membership info. That info is also available
online to the members, I don't do that part. What I need to do is, get any
corrections or changes that I make in my version of the db, to the person who
updates the online directory. How do I do that?
 
The only way your database will know if a record has been added or changed is
if you do one of two things.
One - add a Yes/No field to your member record. When you begin editing, set
the value to True. Also, make the default value of the field True. That
way new records and changed records will have a value of True.

Create a query to extract only those records with that field set to true.
Create an undate query to change them all to False after you have exported
them.

The other way is to put all new and changed records in a temporary table as
you add or edit them. Once they have been exported, you will have to get
them into the permanent table. This will take more work. The first solution
is much easier.
 
Back
Top