Help Needed Badly - Database Crashed

[Aamer]

I have idea either it was virus or the power failure.
my system crashed and when it was re-started the database file is gone and
am left with a file named "Database" I have tried to open the file and am
getting the following errors

ID IS NOT AN INDEX IN THIS TABLE

and another error I get is

PARENT ID NAME IS NOT AN INDEX IN THIS TABLE


Pls pls pls someone help me recover the data.

Help needed extreemly urgent

Thank You
aamer

 

[Aamer]

Please Also Note Am Using Access 2007

 

[John W. Vinson]

I have idea either it was virus or the power failure.
my system crashed and when it was re-started the database file is gone and
am left with a file named "Database" I have tried to open the file and am
getting the following errors

ID IS NOT AN INDEX IN THIS TABLE

and another error I get is

PARENT ID NAME IS NOT AN INDEX IN THIS TABLE


Pls pls pls someone help me recover the data.

Help needed extreemly urgent

Thank You
aamer

eeeeuuuuwwwwwww... I've seen that error message. It's not good.

See http://www.granite.ab.ca/access/corruptmdbs.htm for information and links.

If you don't have backups... well, now you know why it's essential to have
your databases securely backed up. I hope you'll be able to salvage something
but I'm not very hopeful.

 

[Aamer]

When I have oped the Database file I dont see any Tables all I see is
MSysCompactError

I exported this file in excel format and following is in excel file

"You do not have the necessary permissions to use the
'~sq_c~TMPCLP604171~sq_cTrans ID' object. Have your system administrator or
the person who created "

 

[Tom van Stiphout]

On Mon, 4 Jan 2010 16:08:02 -0800, Aamer

You have piled error upon error. After a crash you NEVER operate on
the remaining files, only on copies thereof.
You might be able to open a copy of that file in Notepad and salvage
some data.
For the best data recovery service bar none go to www.pksolutions.com

-Tom.
Microsoft Access MVP

 

[Arvin Meyer [MVP]]

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Aamer]

i geuess i am doomed
nothing worked

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com





.

 

[Arvin Meyer [MVP]]

That's why backups are so important. Very large files, like database files
are more prone to corruption because of their size. There are several
services that may be able to help you for a fee. Try using Bing to enter
"Access database recovery"
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com