Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 How to fix corrupted Visual FoxPro 9 dbf, dbc?, Visual FoxPro 9 error

views
     
TSral.salinas
post Jan 17 2016, 11:15 PM, updated 9y ago

New Member
*
Newbie
3 posts

Joined: Jan 2016


When trying to open tables I get the message "is not a table".

I have tried DBF Recovery and it did not work.

dewill
post Jan 17 2016, 11:22 PM

Regular
******
Senior Member
1,716 posts

Joined: Feb 2006


reli no backup of the database?
alien3d
post Jan 17 2016, 11:33 PM

Look at all my stars!!
*******
Senior Member
3,740 posts

Joined: Mar 2009
QUOTE(ral.salinas @ Jan 17 2016, 11:15 PM)
When trying to open tables I get the message "is not a table".

I have tried DBF Recovery and it did not work.
*
try open with open office
eliasson
post Jan 27 2016, 10:34 PM

New Member
*
Newbie
2 posts

Joined: Jan 2016


"Not a table" means more serious problem than TABLEVALIDATE can fix obviously. Also when DBF recovery fails the problem can be critical (if you have the DBF recovery which supports your DBF file format).

You should look at the DBF header via some hexa editor. You may even use the one from VFP:

DO HOME() + "Tools\HexEdit\HexEdit.app"

It will ask for a file opening so please select your DBF and post first two lines here or look at the DBF structure description in the VFP help.

First two lines (in hex editor) contain the file type, number of records, record size, last update etc. "Not a table" means the first byte was not recognized as valid DBF file marker.
Additional lines contain column descriptions each one in 16 bytes.

More info: http://msdn.microsoft.com/en-us/library/st...8(v=vs.80).aspx
Second easiest fix is use DBF Recovery Toolbox or some other applications. Search in Google. http://www.oemailrecovery.com/dbf_recovery.html

eliasson
post Jan 27 2016, 10:37 PM

New Member
*
Newbie
2 posts

Joined: Jan 2016


Refer to the following thread for some possible solutions.
http://database.ittoolbox.com/groups/techn...f-files-5617688

TSral.salinas
post Jan 31 2016, 08:31 PM

New Member
*
Newbie
3 posts

Joined: Jan 2016


Thank you all for your advice! The issue has been resolved.

TSral.salinas
post Jan 31 2016, 08:32 PM

New Member
*
Newbie
3 posts

Joined: Jan 2016


Thank you guys for your feedback and help. Sorry, that long time did not respond. This is because the issue was solved and I forgot to tell.) Thank you!

zeb kew
post Feb 1 2016, 05:39 PM

Look at all my stars!!
*******
Senior Member
2,325 posts

Joined: Sep 2015
Do tell us how the issue was resolved. Don't keep it a secret unto yourself. This way, if somebody does a search and stumbled onto this thread, they get a tip.
hankc
post Feb 29 2016, 01:07 PM

New Member
*
Junior Member
12 posts

Joined: Jun 2015
Yes, please share with us how you solved the problem. Thanks.

 

Change to:
| Lo-Fi Version
0.0139sec    0.17    5 queries    GZIP Disabled
Time is now: 29th March 2024 - 09:42 AM