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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Give this a shot:
http://support.microsoft.com/default...roduct=acc2000

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"William Poh Ben" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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 ?

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

Gina

"Allen Browne" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Give this a shot:
>
http://support.microsoft.com/default...roduct=acc2000
>
> The article only gurantees it will work if the database has not been
closed,
> but you may get lucky.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
>
> "William Poh Ben" <(E-Mail Removed)> wrote in
> message news:(E-Mail Removed)...
> > 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 ?
>
>

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

http://support.microsoft.com/default...61&Product=acc
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"William Poh Ben" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 9/29/2003

"Gina Whipp" <(E-Mail Removed)> wrote in message
news:%aBfb.91432$(E-Mail Removed)...
> 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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 9/29/2003

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.


"William Poh Ben" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>