Recover Deleted Table for Access 2010

[Mohanmoni]

Hi,

Unfortunately I have deleted table called "Rik" from access table 2010. Now I am looking for suggestion to recover table from the access 2010. Please suggest.

Thank You,
Mohan

 

[Joe4]

As long as you haven't done a "Compact & Repair Database" since deleting the table, it should be available to recover.
See: http://www.accessrepairnrecovery.com/blog/access-database-table-recovery

 

[Mohanmoni]

It doesn't work Joe.

 

[stumac]

Is your database split? Is the table definitely away and not just a link to the backend?

Do you have a backup that will do?

I have used this successfully once before (as a test a good few years ago): http://www.databasedev.co.uk/recover_deleted.html

If you have compact on close selected then you will have lost the table.

If you haven't got a regular backup set up then you should do so now, as with most types of DB's it is very easy to corrupt/overwrite/delete data from the back end and often the only recovery option is a backup.

 

[Joe4]

It doesn't work Joe.

stumac summarized it pretty well. If you have done a "Compact & Repair" the database since deleting the table, you should be able to do it, if you are doing it correctly.
Of course, that is assuming that the data is in a native Access table, and not linked in from elsewhere. If it is a linked table, you will probably need to restore it from that application, whatever it may be.

However, if you have already done a "Compact & Repair", you only option is to restore from a backup.
If you do not have a backup, then you are out of luck. And it is time to start a backup schedule. Access databases can get corrupted from time-to-time, so it is essential to run regular backups.
If you do not, you are playing with fire, and it is probably only a matter of time until you get burned.