Find missing record in backups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm faced with a really ugly situation. I have a database where a user/users (unknown) have deleted records by "accident" over a period of time. Only now has it come to my attention the records are missing. I have looked through some of my daily backups and found that they have been deleted over several day (not in one action). As such I cannot just link to one specific backup and update the data.

My question is, is there a way for me to cross-reference an access table containing a listing of the missing entries and automatically compare them to the record found in each backup file. I want at the end of the day to have a listing of the latest backup to contain the missing record.

thus
xyz might be may1
wye might be apr23
....

If you have any inspirations, please send them my way.

Daniel
 
You'll find code to "relink tables at startup" that you can use to change
your links to the tables in a different database in the Solutions9.mdb from
Microsoft, temporarily housed at
http://www.mvps.org/access/downloads/bapp2000.exe.

With that, you can create a query joining the items in the "known missing"
table with the pertinent table in the backup and extract the originals, if
found. You can use the Windows Common Dialog (see api0001 at the same site)
or write code to cycle through your backups.

But, I suspect it will be simpler just to use the Linked Table Manager
unless you have to look through a _humungous_ number of backups.

Larry Linson
Microsoft Access MVP


Daniel said:
Hello,

I'm faced with a really ugly situation. I have a database where a
Click to expand...
user/users (unknown) have deleted records by "accident" over a period of
time. Only now has it come to my attention the records are missing. I have
looked through some of my daily backups and found that they have been
deleted over several day (not in one action). As such I cannot just link to
one specific backup and update the data.
My question is, is there a way for me to cross-reference an access table
Click to expand...
containing a listing of the missing entries and automatically compare them
to the record found in each backup file. I want at the end of the day to
have a listing of the latest backup to contain the missing record.
 
Back
Top