When trying to open tables I get the message "is not a table".
I have tried DBF Recovery and it did not work.
How to fix corrupted Visual FoxPro 9 dbf, dbc?, Visual FoxPro 9 error
How to fix corrupted Visual FoxPro 9 dbf, dbc?, Visual FoxPro 9 error
|
Jan 17 2016, 11:15 PM, updated 9y ago
Show posts by this member only | Post
#1
|
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. |
|
|
|
Jan 17 2016, 11:22 PM
Show posts by this member only | Post
#2
|
Senior Member
1,716 posts Joined: Feb 2006 |
reli no backup of the database?
|
|
Jan 17 2016, 11:33 PM
Show posts by this member only | Post
#3
|
Senior Member
3,740 posts Joined: Mar 2009 |
|
|
Jan 27 2016, 10:34 PM
Show posts by this member only | Post
#4
|
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 |
|
Jan 27 2016, 10:37 PM
Show posts by this member only | Post
#5
|
Newbie
2 posts Joined: Jan 2016 |
Refer to the following thread for some possible solutions.
http://database.ittoolbox.com/groups/techn...f-files-5617688 |
|
Jan 31 2016, 08:31 PM
Show posts by this member only | Post
#6
|
Newbie
3 posts Joined: Jan 2016 |
Thank you all for your advice! The issue has been resolved.
|
|
Jan 31 2016, 08:32 PM
Show posts by this member only | Post
#7
|
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!
|
|
Feb 1 2016, 05:39 PM
Show posts by this member only | Post
#8
|
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.
|
|
Feb 29 2016, 01:07 PM
Show posts by this member only | Post
#9
|
Junior Member
12 posts Joined: Jun 2015 |
Yes, please share with us how you solved the problem. Thanks.
|
Change to: | 0.0139sec
0.17
5 queries
GZIP Disabled
Time is now: 29th March 2024 - 09:42 AM |