[AccessD] Corrupt Data File

Terry:

Look at http://support.microsoft.com/default.aspx?scid=kb;en-us;158933 for
some help...although it's not help really...it just tells you how hosed
you really are.  I had a client who got this error message and there was
absolutely nothing we could do with it.  The backend data was corrupted
beyond repair.  We couldn't even import the data out of it.  She had to go
and use the last backup, which I conveniently had a copy of, but it was
over two weeks old.  Her tape drive had not been working right (and she
knew it...but put off getting it fixed...) so her backup was missing over
two weeks of data they had to reenter.  I hope this is NOT the case for
you, but, judging from the Microsoft article, I don't hold out much hope.

Good luck!

Greg Smith
gregsmith at starband.net

>> > Help!!
>> >
>> > I have a store management database application in Ac97 and last
>> night
>>the
>> > back end data file was corrupted.  I have run the Ac97 repair tool
>> and
>>also
>> > Jetcomp.exe on the file and they both say the file is OK.
>> >
>> > The problem is when I attempt to open it I get the following
>> message:
>> >
>> > "'Index1' isn't an index in this table. Look in the indexes
>> collection
>>of
>> > the TableDef object to determine the valid index names." OK /HELP
>> >
>> > Clicking on the OK button just terminates the opening process.  Due
>> to
>>an
>> > undiscovered (until now!) quirk in our backup system, this file has
>>never
>> > been backed up.  The file size is 7.2Mb and contains about 7000
>> records.
>>A
>> > zipped copy is about 1.6Mb.
>> >
>> > Any advice on how or who could fix it would be most appreciated.
>> >
>> > Terry Mace
>> > BAE Systems
>> > Melbourne, Australia