Author: Jack Skelley
Posted: 2000-01-12 at 16:27:00
Good Afternoon:
Exactly the problem...the CDX was corrupt!
I deleted the CDX and rebuilt it and all appears ok.
Thanks to all who replied. This project is very visible in the organization and
it wasn't looking good for yours truly.
In the daze <g> of FPW/FPD I would dive right in with my hex editor and rebuild
the header. But now with DBC's I'm not so sure of myself. Being chicken is a
better part of valor...
Thanks again for the help.
Jack Skelley
skelley@newjerseydevils.com
sherman@compassres.com wrote:
> 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. ----------------------------------------
> >
> >
> >
>
> ----------------------------------------
> 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.
> ----------------------------------------
>