>>>>Hi all,
>>>>i am having trouble with a table. everytime i try to open it, it give me a message saying "file is not open". not matter what i do i can't open this table. i have tried fptfix, fixfoxpo, atfixdbffpt (gave me parameter errors) to no avail. is there anything else i can try?
>>>>
>>>>thanks
>>>>Jordan
>>>
>>>What is the name of the table? VFP may be renaming the alias, if it starts with a digit or includes spaces.
>>
>>it is just compdtl.dbf. no spaces. no numbers. nothing. i think the table is unrecoverable
>
>That is indeed quite probable. What surprises me, though, is that a corrupted table usually gives a different error message, IIRC, something like "is not a database", but not "file is not open". Is the exact error message?
"File is not open" is the exact error. i, like you was not expecting such an error. and i sure can't tell how to fix it. looks like a restore to backup for my client (who knows when that would have been).
Jordan Pastourel
Development Manager