corrupt index and index out of date problems

Michael Fleet

Delphi Developer

Wed, 02 Feb 2005 23:40:46 GMT

corrupt index and index out of date problems

Hey gang.

Here is the necessary info:

BDE: 5.1.1
PARADOX 7
Delphi 5 App
Winows NT 4 Server
Windows 98 Work stations
Local Share = True
TCP/IP is the only protocol installed

I thought that setting LocalShare to true prevents index errors. However,
they still occur. Is there another setting that must be set in order to
prevent these errors? Even after rebuilding the indexes with tutil, the
indexes are again corrupted after a couple of transactions. Is this a
problem on the NT server or is it the workstations?

Any help will be greately appreciated

Michael Flee

Delphi Developer

Thu, 03 Feb 2005 21:33:59 GMT

Re:corrupt index and index out of date problems

Thanks Art.

But by UPS, do you mean Uninterruptible Power Supply? If so, how does this
help?

Thanks a lot!

Quote

"Art Begun" <beg...@mindspring.com> wrote in message

news:3d5e78eb$1@dnews...

Quote

> Turn off opportunistic locking in NT.

> All machines must have a UPS.

> The application should explicitly close all files before the
> application closes. I gives the bde time to clean up.

> If that doesn't make it reliable (assuming the application doesn't
> lock up and people don't exit it improperly) then I would look for a
> bad network card some where.

> "Michael Fleet" <michael.fl...@sympatico.ca> wrote in message
> news:3d5e6e7c$1@dnews...
> > Hey gang.

> > Here is the necessary info:

> > BDE: 5.1.1
> > PARADOX 7
> > Delphi 5 App
> > Winows NT 4 Server
> > Windows 98 Work stations
> > Local Share = True
> > TCP/IP is the only protocol installed

> > I thought that setting LocalShare to true prevents index errors.
> However,
> > they still occur. Is there another setting that must be set in
> order to
> > prevent these errors? Even after rebuilding the indexes with tutil,
> the
> > indexes are again corrupted after a couple of transactions. Is this
> a
> > problem on the NT server or is it the workstations?

> > Any help will be greately appreciated

Art Begu

Delphi Developer

Fri, 04 Feb 2005 03:36:28 GMT

Re:corrupt index and index out of date problems

Yes. If the power blinks and any of the machines are accessing the
files the indexes are toast. UPS's are so cheap now they should be on
every machine accessing Paradox files to avoid problems.

Quote

"Michael Fleet" <michael.fl...@sympatico.ca> wrote in message

news:3d5fa22f$1@dnews...

Quote

> Thanks Art.

> But by UPS, do you mean Uninterruptible Power Supply? If so, how
does this
> help?

> Thanks a lot!

> "Art Begun" <beg...@mindspring.com> wrote in message
> news:3d5e78eb$1@dnews...
> > Turn off opportunistic locking in NT.

> > All machines must have a UPS.

> > The application should explicitly close all files before the
> > application closes. I gives the bde time to clean up.

> > If that doesn't make it reliable (assuming the application doesn't
> > lock up and people don't exit it improperly) then I would look for
a
> > bad network card some where.

> > "Michael Fleet" <michael.fl...@sympatico.ca> wrote in message
> > news:3d5e6e7c$1@dnews...
> > > Hey gang.

> > > Here is the necessary info:

> > > BDE: 5.1.1
> > > PARADOX 7
> > > Delphi 5 App
> > > Winows NT 4 Server
> > > Windows 98 Work stations
> > > Local Share = True
> > > TCP/IP is the only protocol installed

> > > I thought that setting LocalShare to true prevents index errors.
> > However,
> > > they still occur. Is there another setting that must be set in
> > order to
> > > prevent these errors? Even after rebuilding the indexes with
tutil,
> > the
> > > indexes are again corrupted after a couple of transactions. Is
this
> > a
> > > problem on the NT server or is it the workstations?

> > > Any help will be greately appreciated

Other Threads

1. Corrupt Index, Index Out of Date and Corrupt Header - Paradox

2. Corrupt lock files, Index out of date etc.

3. Corrupted Tables and Index out of date.

4. Index out of date, but no index

5. Index Error - Index out date

6. Index out of date even when no index defined

7. Create index of Paradox table -- always index is out of date

8. corrupt index/header problem

9. Problem reading dbase III files - corrupt table/index header

10. problems with corrupt index in a table...