MACE, Terry
terry.mace at baesystems.com
Wed Nov 17 23:41:04 CST 2004
Borge, That worked! I didn't think to try that - there was a corrupted test report that I don't need, so all the data is safe - yea! Thanks Terry -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of pcs at azizaz.com Sent: Thursday, 18 November 2004 13:50 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Corrupt Data File 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