Access History

[Molden]

Hi,

Could someone help me. I've deleted records in my database which I need back and dont no which ones I've done.

Is there away to open the database so it shows what was in there yesterday so I can re populate the table?

Thanks in advance

Michael

 

[SydneyGeek]

Do you have a backup? If not, the data is gone. Unfortunately there is no undo for deletion, and no recycle bin.

If the data is important back it up daily. If it's really important back it up several times a day, especially before you do anything major with the data.

Denis

 

[Molden]

Hi,

Thanks for the reply. I've heard you can type in the filepath its stored in the explorer and put something like ~1 at the end to go back a day. Have you heard of anything like this?

 

[SydneyGeek]

Nope. If that trick exists it's news to me. I would say your data is gone, if you don't have a backup.

Denis

 

[bkelly]

Is it difficult to implement a logging feature? As each change is made it is put in, maybe, a table or just a simple file of records with a tag for where the record belongs. (probably needs additional info such as before, after, who did it, and time stamps) I suspect that higher end databases has this built in, but how difficult is it for Access?

 

[SydneyGeek]

Yes, you can. Here is one way.
It takes some setting up (depends which tables you want to protect / log), but there is no substitute for regular backups. And if the database is split, that is a backup of the back end tables...
The logging helps you if a few records are removed or changed.

Denis