how to get back the table I deleted accidentally

  • Thread starter Thread starter William Poh Ben
  • Start date Start date
W

William Poh Ben

Hi,

I have saved the Access2000 database in my local drive C:
Does anyone know if I accidentally deleted an important table, how can
I undo to get back this table which conatins all the important
information ?

Thanks in advance.
 
Gina Whipp said:
Umm, I hope you made a backup because I don't believe you can get anything
back, including a table once it has been deleted. If someone know
differently, I'd be interested to hear how....
Click to expand...

Hi Gina,

Read the KB articles that Allen and I have cited. You can get back the
*last* table you have deleted *if* you haven't closed the database, and, of
course, if you haven't overwritten it. This only applies to JET tables, not
SQL-Server tables.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Umm, I hope you made a backup because I don't believe you can get anything
back, including a table once it has been deleted. If someone know
differently, I'd be interested to hear how....

From past experience.... yep I think everyone has doen something similar
once, I now make backup copies of my database while working on it and as I
store the backends on servers I warn people to make sure that data is backup
daily. That way at most you lose a days worth of records.
 
Back
Top