I'm working with a clients database and one of the tables is corrupted. I
was able to rebuild the DDF Files using the utility out of Control Center,
but I'm still unable to access all of this table file.Control Center says
there are around 65K records, but when I try to query for the last record in
Control Center it hangs around 19K records.

I tried to open the file with Wordpad just to see if it was there and
Wordpad got stuck in a loop. Wordpad said it had 12% of the file loaded and
then would got back to loading 1% of the file. Trying to open it with
Notepad produced similar results.

I am able to copy and move the file and NTFS doesn't have a problem with it.

Any suggestions on a tool or method that will let me find what's wrong with
this file?

Environment:
XP Pro
Pervasive V9 SP1 Workgroup Edition
Data crated by Lytec XE application

Bernie

You can take a look at BtSearch32 at www.nssdd.com. It has some file
repair abilities that includes reviewing the PAT pages of your file.
Sometimes the PAT pair may become corrupt or you may have a corruption
within the file. Error's 2 usually indicate a corrupt file.

Gil

Bernie Hunt wrote:

If needed, we can also help with file corruption & recovery. See our
web site at www.goldstarsoftware.com/recovery.asp for more information.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - March, 2006 ***
*** Chicago: Pervasive DataExchange Class - March, 2006 ***

Bernie Hunt wrote:

Kind of strange.
You don't actually mention anything that would specifically indicate a
corrupt database file.
The DDFs only contain the SQL schema (file field and index
information) for the existing Btrieve files. Rebuilding those doesn't
change their content so the data will be represented the same way
through the SQL engine. Also, the DDFs only contain SQL schema
information and no "user" data.

You don't mention specifically which Pervasive Control Center you are
using. The 9.x one has quite different behavior then previous
versions. It does in fact have a problem with displaying the correct
number of records that are in a file as well as a grid that is much
more limitted than previous versions for showing data.

I would probably start by doing a butil -stat on the data file and
seeing how many records it is supposed to actually have.

Might want to use a different tool to look at the data than PCC due to
the above mentioned limitations. MS Access springs to mind but again
the grid is an "in memory" construct so it is limitted, well, by the
amount of memory available to it. Notepad and Wordpad are also "in
memory" types of applications, although the behavior described is not
what I have seen before using them... ODBCtest springs to mind as
well as there are a couple of freeware command line SQL executors
available from the Component Zone utilities listing, 2nd page shows a
couple:
http://www.pervasive.com/ComponentZo...+%2F+Utilities
No "memory" limitations with them as they dump to screen or log file.

Leonard

On Wed, 4 Jan 2006 10:35:36 -0500, "Bernie Hunt" <bhunt (AT) optonline (DOT) net>
wrote:

There's some freeware to recover corrupt DBF files:
http://www.s2services.com/dbasefreeware.htm.