Detect Database Usage 1

[oldrod]

Is there a simple method to detect whether a backend database has changed while the database is open? I am archiving backups and want to determine if a backup will be effective in a selected time interval. I've considered several approaches that involve logging record inserts, deletes and updates for each form. This seems like overkill when I only need to set a change/no change flag.

Thanks -

RC

 

[BNPMike]

Maybe you want to let Jet do the work for you. Why have a dog and bark yourself (tm)?

If you set up replication you can replicate the database rather than back it up. Access will then only save any changes that have been made. If there aren't any, it won't save any.

 

[oldrod]

Thanks for the tip Mike. Looks like I was overworking the problem.