[AccessD] Corrupt Data File

I had the same/similar problem a few months ago...If I tried to 
import,export, or compact...I would get that error.  It seemed to revolve 
around 1 record( with a memo field)...when viewing the memo 'error' 
appeared.  I removed this record...and was able to compact.

Good Luck,

Mark A. Matte

>From: <pcs at azizaz.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Corrupt Data File
>Date: Thu, 18 Nov 2004 12:50:16 +1000
>
>Are you able to import the backendDb tables into a new empty db?
>
>Regards
>Borge
>
>----- Original Message -----
>From: "MACE, Terry" <terry.mace at baesystems.com>
>To: "'Access Developers discussion and problem solving'"
><accessd at databaseadvisors.com>
>Sent: Thursday, November 18, 2004 11:36 AM
>Subject: [AccessD] Corrupt Data File
>
>
> >
> > 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
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
>---
>Outgoing mail is certified Virus Free by AVG Anti Virus System.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.773 / Virus Database: 520 - Release Date: 6/10/2004
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com