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
Jack-
Just a shot, but have you tried to VALIDATE DATABASE RECOVER ?
Matthew S. Jarvis
mattjarvis@ipkoke.com
Programmer, MIS Department
-----Original Message-----
From: Jack Skelley [mailto:Skelley@NewJerseyDevils.com]
Sent: Tuesday, January 11, 2000 4:08 PM
To: Multiple recipients of ProFox
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.
----------------------------------------
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 ?
>
> Matthew S. Jarvis
> mattjarvis@ipkoke.com
> Programmer, MIS Department
>
> -----Original Message-----
> From: Jack Skelley [mailto:Skelley@NewJerseyDevils.com]
> Sent: Tuesday, January 11, 2000 4:08 PM
> To: Multiple recipients of ProFox
> 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.
> ----------------------------------------
>
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
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. ----------------------------------------
>
>
>
Sorry Jack, but I'm afraid I can't offer any other ideas. I think the other
replies are on line with what I would suggest, being that the DBC header is
corrupt in some way. This may take a commercial utility to correct. I've
never been too keen on hacking HEX codes myself.
Matt
-----Original Message-----
From: Jack Skelley [mailto:Skelley@NewJerseyDevils.com]
Sent: Wednesday, January 12, 2000 5:35 AM
To: Multiple recipients of ProFox
Subject: Re: VFP6: File is not open error
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 ?
>
> Matthew S. Jarvis
> mattjarvis@ipkoke.com
> Programmer, MIS Department
>
> -----Original Message-----
> From: Jack Skelley [mailto:Skelley@NewJerseyDevils.com]
> Sent: Tuesday, January 11, 2000 4:08 PM
> To: Multiple recipients of ProFox
> 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.
> ----------------------------------------
>
----------------------------------------
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.
----------------------------------------
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.
> ----------------------------------------
>
I have one table, not that large (only 5600+ recs) that will not open and
the only error I get from VFP is
a 'File is not open' error. This error pops up in a message box with a
yelow triangle on the left side with
a exclamation mark in it.
I thought maybe the table is damaged, so I ran CMRepair against (which has
been very good to me in the
past) and checks the table out as being OK.
I need some help here because this table holds the demographics against some
special patients we
see here at the 6th Medical Group.
TIA,
Steve
Steve,
Copy the .cdx file to a different name and then try to open the table.
I have only ever gotten this error because of a bad, corrupt or invalid index.
You will have to rebuild the .cdx file by hand.
Good luck!
Wolfe Stephen S Civ GS-11 wrote:
> I have one table, not that large (only 5600+ recs) that will not open and
> the only error I get from VFP is
> a 'File is not open' error. This error pops up in a message box with a
> yelow triangle on the left side with
> a exclamation mark in it.
>
> I thought maybe the table is damaged, so I ran CMRepair against (which has
> been very good to me in the
> past) and checks the table out as being OK.
>
> I need some help here because this table holds the demographics against some
> special patients we
> see here at the 6th Medical Group.
>
> TIA,
>
> Steve
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>
Steve:
Any index files? I've had this happen before when an index file becomes corrupt.
When I erased the index file and opened the table this error went away. Then I
rebuilt the index.
Then all was right with the world.
HTH
Jack
skelley@newjerseydevils.com
Wolfe Stephen S Civ GS-11 wrote:
> I have one table, not that large (only 5600+ recs) that will not open and
> the only error I get from VFP is
> a 'File is not open' error. This error pops up in a message box with a
> yelow triangle on the left side with
> a exclamation mark in it.
>
> I thought maybe the table is damaged, so I ran CMRepair against (which has
> been very good to me in the
> past) and checks the table out as being OK.
>
> I need some help here because this table holds the demographics against some
> special patients we
> see here at the 6th Medical Group.
>
> TIA,
>
> Steve
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>