By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,843 Members | 1,544 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,843 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.

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

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 ?

Nov 20 '06 #2

P: 2

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

Nov 20 '06 #3

Expert Mod 10K+
P: 14,534

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

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.

Nov 20 '06 #4

Post your reply

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