Further to my earlier note - once you've removed the index you can always reapply it.
> Paul Crisp > Syntegra > > Direct: 0191 461 4522 > Mobile: 0776 414 3762 > Fax: (0191) 461 1959 > > Innovation Place Metro Riverside Park > Delta Bank Road Gateshead Tyne & Wear NE11 9DJ > -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 09:42 To: [EMAIL PROTECTED] Subject: RE: MI-L File retrieval after MI crash Dave, The IND file is holds the indexing information for the table. You need to index fields in order to use Query / Find. It also speeds up comparison queries and joins. Andrew Young Durham City UK > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 21 May 2002 08:33 > To: [EMAIL PROTECTED] > Subject: Re: MI-L File retrieval after MI crash > > > On 21 May 2002 at 16:45, Doug Pease > <[EMAIL PROTECTED]> wrote: > > > I have just experienced a MI crash while packing a table. > Following the > > crash I tried to locate the table that was being packed > only to find that > > they'd disappeared. The temporary files exist and I renamed > them to the > > appropriate file extensions but the IND file is not there. > I am unable to > > open the renamed temporary files after trying everything I know > > Is the IND file really needed? I have seen this file on > occasions, but most > of my tables don't have this file anyway...they just have the > 4 standard > files: *.map, *.id, *.dat & *.tab. > > Possibly if it is looking for it, then whichever other file > in the table > wants it can be modified slightly so that it doesn't need the > IND file? No > idea how though... > > Dave > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > IMPORTANT NOTICE: This e-mail is confidential. It must not be read, copies disclosed or used by any person other than the main recipient. Unauthorised use, disclosure or copying is strictly prohibited and may be unlawful. If you have received this e-mail in error, please contact the sender immediately. ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.syntegra.com ********************************************************************
