> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Eion McIntosh
> Sent: Thursday, 25 November 1999 20:45
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Index out of Date
> Patrick Dunford wrote:
>
> >
> > There are two major possibilities
> >
> > 1. You are using a non maintained secondary index. Change all
> such indexes
> > to maintained and this problem will disappear.
> > 2. Your indexes are getting corrupted. Various fixes which
> include flushing
> > all the data to disk each time you post, have been suggested here in the
> > past.
> >
> > How frequently is "periodically"?
>
> This has happened three times in the last 5 months.
That's not very frequent. I had a customer had that happen 3 times in three
weeks.
- If they are on a network, make sure they have all the MS network
redirector patches (there are several)
- Every time you do a post, explicitly (call table Post method) or
implicitly (in the AfterPost event of the table) do a DbiSaveChanges call
passing the table's Handle parameter. This will flush out the data caches,
it may also slow performance somewhat.
- Are they shutting down the computer properly, was there a power failure,
did the computer lock up and have to be reset?
- This is a known problem area with BDE databases (dBase/Paradox). It is
rarer but not unknown to get an Access database corrupted. A repair tool may
be useful. TTUtility from O2A is a good component set to roll your own on.
============================================
Patrick Dunford, Christchurch, NZ
http://patrick.dunford.com/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
