Jack:

Sounds like the header may be corrupted. If so, one of the DBF recovery

packages, like Stonefield, might fix it. You can look at the header with a

Hex editor and compare what you see to the descriptions.

At worst, you should be able to kill the byte that says its part of a DBC,

and then fix/recover it as a free table.

Dan Covill

Middleton Consulting, San Diego

At 08:34 AM 1/12/2000 -0500, you wrote:

>Matt:

>Yes I tried validate database recover. I get a message saying it can't

open the

>table; would I like to delete the object or cancel the validation.

>I really don't know what caused this to happen. And the user has no backup of

>this 16MB table with its 17MB FPT.

>Any other ideas?

>Thanks for the help.

>

>Jack Skelley

>skelley@newjerseydevils.com

>

>

>Matt Jarvis wrote:

>

>> Jack-

>>

>> Just a shot, but have you tried to VALIDATE DATABASE RECOVER ?

>>

>>

>> -----Original Message-----

>> From: Jack Skelley [mailto:Skelley@NewJerseyDevils.com]

>> Subject: VFP6: File is not open error

>>

>> Good Evening All:

>> I have a table that belongs to a database. This table has an index file

>> (cdx) and an fpt.

>> When I try to open the table I get and error message "file is not open".

>>

>> The docs say:

>> File is not open (Error 1113)

>> You have attempted to read from, or write to, a file that is not

>> currently open.

>> I suspect the user shut the box off while the table was being written to

>> but not sure...

>> How do I fix this?

>> Thanks for the help.

>>

>> Jack Skelley

>> skelley@newjerseydevils.com