IS THERE A WAY TO IDENTIFY RECORDS(FIELDS) UPDATED BY AN UPDATE QUERY?

[Paul7905]

There is an access database in which users are able to modify, delete or add new records on a daily basis.&nbsp;&nbsp;<br><br>I have created another database which has links to the tables in the database maintained by the users.&nbsp;&nbsp;I maintain certain tables in this new database via update, delete and append queries.&nbsp;&nbsp;<br><br>I am looking for a way to identify the records that have been affected by the &quot;update&quot;, &quot;append&quot; and &quot;delete&quot; queries so that I can periodically create a table that contains only the records that have been added, updated and deleted (the deleted records seem to be somewhat of a problem as they will be absent from the tables when I want to create the file of changes!&nbsp;&nbsp;Perhaps there is a way to save these in a temporary table when the delete query tosses them ?)&nbsp;&nbsp;Any ideas on how to do this would be appreciated.<br><br>Paul

 

[DougP]

I'd start at the beggining?<br>How do your users add new records?<br>If they clicked a Save Record button which could save the information to 2 tables or more.<br>Also if you put in a extra Date/Time column in one or both tables then you could compare dates and times to earlier items etc.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Paul7905]

I do not have any control over the application in which the users make changes.&nbsp;&nbsp;It is a seperate application (purchased package application).&nbsp;&nbsp;I merely link to some tables in this package. I obtain some data for my app by running three queries, an update, an append and a delete.&nbsp;&nbsp;What i want to know is, is there a way, when I run these queries, to identify what, in my tables, was updated, deleted or added.&nbsp;&nbsp;<br>Paul