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

> http://www.ipkoke.com

>

> -----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.

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

>