how to get back the table I deleted accidentally

[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.

 

[Allen Browne]

Give this a shot:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209874&Product=acc2000

The article only gurantees it will work if the database has not been closed,
but you may get lucky.

 

[Gina Whipp]

Allen..
I just learned something new... I thought once gone it was gone...

Gina

 

[Arvin Meyer]

Try this KB article if you haven't closed the database:

http://support.microsoft.com/default.aspx?scid=kb;en-us;179161&Product=acc
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer]

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....

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

 

[Gina Whipp]

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.