How to recover deleted records from Access Table

[TSWA]

Hello, somebody was working on a special table in Access and delete important Records from the Table(a lot of records). Is possible that exist a technique or utility to recover these records from Access Table.

Thanks in advance,

Marlon

 

[Guest_imported]

To my knowledge you cannot recover any deleted object in Access.

In hind sight, I always work off the server because it has a back-up system. I never rely on this for many reasons. I make a habit of backing up my Access databases on my local C-drive, very frequently, especially when I've just done a lot of work, or before risky procedures.

Another trick: instead of deleting a table, query, report, just rename it to say from tblEmployeeData to tblEmployeeDataJunk. That way it's still there and you can delete it at some other point. You can even date it i.e. tblEmployeeJunk1-25-03

Good luck

 

[BillPower]

In Help, you could take a look at .undo and .oldvalue

 

[Transcend]

Hi there

i dont think there is anyway to do this unless your database is on a file system or server somewhere that gets regularly backed up?

Transcend

 

[Elysium]

One other point to remember is that it is possible to recover deleted tables from Access. Are you ready for the catch though? This can only be done if, and only if, the database has not been closed. If you close it, kiss your data (and maybe something else) goodbye.

RS

 

[Fubear]

I feel your pain. Just yesterday I ran a query that blanked a table I had spent 3 days checking the data aginst about half a dozen excel spreadsheets. The deadline for having accurate information was later that day.

Luckily for me, once I had recovered from my panic, I realised I had messed up the query and blanked the wrong table, one I could rebuild from data I had in other tables.

My first action was to immediately back everything up.

I backup all my work first thing in the morning, overwriting the previous days backup, so at worst I am a day out of date.

Backup regularly is the one tip I will give every Access eveloper on this forum.