I usually get this error when I have a blown index.

Try renaming the .cdx file something else and re-creating it.

Send reply to: profox@leafe.com

Date sent: Wed, 12 Jan 2000 09:32:35 -0800

From: Dan Covill <dcovill@san.rr.com>

To: Multiple recipients of ProFox <profox@leafe.com>

Subject: Re: VFP6: File is not open error

> 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

>

>

>

> ----------------------------------------

> To unsubscribe, send a message to: macjordomo@leafe.com, and include the

> line

> UNSUBSCRIBE profox

> in the message body. Or go to http://leafe.com/mailListMaint.html and

> follow the instructions there. ----------------------------------------

>

>

>