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
>
Sorry, that should be RENAME the .cdx file to a new name.
Todd Sherman wrote:
> 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
> >
> >
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>
That was it. Odd, that cmrepair didn't pick up on that. Must be some type
of corruption he isn't looking for ...
Thanks,
Steve
> -----Original Message-----
> From: Todd Sherman [SMTP:sherman@compassres.com]
> Sent: 03 April, 2000 10:16 AM
> To: Multiple recipients of ProFox
> Subject: Re: VFP6.0: File is not open
>
> 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
> >
> >
>
>
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>
The index may look valid.
For example, if you open the table with an alias, and create the index using
the alias as part of the field name, when you open the table again, you had
darn well better use the same alias.
ie, use mytable alias detail
index on detail.ordamt
use mytable
will blow an error... so will the following, I think:
use mytable
index on mytable.ordamt
use mytable alias detail
Kinda hard to check. The index isn't corrupt per se.
Wolfe Stephen S Civ GS-11 wrote:
> That was it. Odd, that cmrepair didn't pick up on that. Must be some type
> of corruption he isn't looking for ...
>
> Thanks,
>
> Steve
>
> > -----Original Message-----
> > From: Todd Sherman [SMTP:sherman@compassres.com]
> > Sent: 03 April, 2000 10:16 AM
> > To: Multiple recipients of ProFox
> > Subject: Re: VFP6.0: File is not open
> >
> > 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
> > >
> > >
> >
> >
> >
> > ----------------------------------------
> > Subscription maintenance at:
> > http://leafe.com/mailListMaint.html
> >
> >
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>