By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Finding Dirty Records In Access

P: 2
I want to identify records that have changed since the last export. Is there a record property or some method to identify when it was last changed?

I am using Access97 and 2003.

Thanks
Nov 20 '06 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
Sorry to disappoint you, the only option is to use code for this.
You'll have to add a DateLastUpdated in every record and save somewhere the DateLastExported.
Now when a record is changed on a form set the DateLastUpdated equal to Now().
For direct table updates this won't work !

The only other alternative is to use another database like Oracle or S SQL that does allow code to be executed on the change of a record...

Need more information ?

Nic;o)
Nov 20 '06 #2

P: 2
Nico

Thanks for the info. This is what I was dreading.

Thanks
Nov 20 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Nico

Thanks for the info. This is what I was dreading.

Thanks
Welcome to the world of Access Gary.

Most of us have some standard Auditing routines built into our code like creating system logs to record all significant transactions on the database like login, logout, updates, additions, deletions (when we allow them). I have a trigger that dumps my log to a text file whenever I reach a certain number of records. You could use the aforementioned export as the trigger.

Mary
Nov 20 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.