How do I detect new records.

[jcollins]

I have written a batch script to open a particular access db once a day.

The database accepts input from a webform.



I would like to have access automatically determine if any records have been added to a table since the last time it was opened and, if so send emails to particular addresses containing information from the new records.

Right now I am stuck on how to automatically detect the new records.

Any help is greatly appreaciated.

[ajetrumpet]

what's your best guess on how to do it? There's countless ways.

[jcollins]

what's your best guess on how to do it? There's countless ways.

Well I was thinking that I would write a script that would select the ID number of the newest record (not sure how to do that) compare that to a list of the ID's of records that had already been processed. If the ID wasn't in the list then, then it would be processed (meaning selected fields would go into an email to a particular user). Then the script would go to the next newest ID and compare it to the already processed ID list. The same logic would apply. This would loop until an ID that was processed was found and then the script would shut access down.

Somewhere in there the new ID's would be added to the "already processed" list.

[ajetrumpet]

Well I was thinking that I would write a script that would select the ID number of the newest record (not sure how to do that) compare that to a list of the ID's of records that had already been processed. If the ID wasn't in the list then, then it would be processed (meaning selected fields would go into an email to a particular user). Then the script would go to the next newest ID and compare it to the already processed ID list. The same logic would apply. This would loop until an ID that was processed was found and then the script would shut access down.

Somewhere in there the new ID's would be added to the "already processed" list.

that could work, but you have to figure out "how" you know that the records have been processed. that's the variable here.

what is the indicator? field? or something else?