Question

Locked

How I view the contents of a damaged dbf file ?

By artuaslella ·
Tags: Windows, Software
I want to view the contents of a dbf file but one column appears with
"strange characters". It seems to be locked or encoded or encrypted. I
can see the other columns with no problem. The problem exists only in
one column. Is it possible to "unlock or decode or..." and view the
contents of that column?
For viewing the contents of the dbf file, I use the programs:
- DBF Viewer 2000 v1.35
- DBF Viewer Pro

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

I think you have a dbase file that is corrupted

by ralfeger In reply to How I view the contents ...

Hi.I'm not completely certain but I think you have a dbase file that is corrupted. I believe that if it was encrypted, you wouldn't be able to read any of the fields. But you can try view file with help DBF Viewer Tool. http://www.dbf.viewertool.com/
- Advanced file analysis engine allowing users to view FoxPro files that were seriously damaged in all sorts of data corruption incidents
- An integrated database browser that assists users who don’t know how to view corrupted dbf file data
- Recovery of the database structure, data and associated MEMO field files
- Possibility to manually specify the format of the output DBF file
- Detailed database recovery log.
Read more information here:
http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/257-​i-want-to-view-the-contents-of-a-dbf-file?_=1413548488602

Collapse -

Perform these actions to resolve this issue

by donaldreynolds In reply to How I view the contents ...

You need to create an environment under which the table is NOT validated when it is opened. This can be achieved by the command -SET TABLEVALIDATE TO 0. Now you can easily open your tables.

These are some “Prevention Steps” to prevent your data from corruption:

Try to put a code in your program that automatically creates a duplicate copy of your tables (columns & rows), index files and databases.
Set-up a back-up routine.
Inform the user to properly shutdown the computer and regularly perform back-up.
Use UPS for power back-up.
Please click accept and leave feedback if you are satisfied with my answer.

Collapse -

Try opening the .dbf file in Excel or other program opening the .dbf format

by johnfranklin1 In reply to How I view the contents ...

Once opened in Excel you should be able to view the file, delete any "bad data", and resave to a new name (with the .dbf extension).

Also possible to create a new table with the structure of the old table, append records from the old to the new. May salvage records until the corruption is encountered.


YOU CAN USE THE ALPHA UTLILITY 'COPY DATABASE', BUT CHOOSE NOT TO INHERIT SUPPORT FILES.

SO IF THE CORRUPT DATABASE IS CALLED 'HEADER.DBF', COPY USING THE UTILITY 'COPY DATABASE' IT TO A NEW ONE CALLED 'NHEADER.DBF' WITHOUT INHERITING SUPPORT FILES.

THEN FROM DOS (BY PRESSING ALT F9) RENAME THE DATABASE.

REN HEADER.DBF AHEADER.DBF (RENAMES THE CORRUPT DATABASE TO AHEADER.DBF)

REN NHEADER.DBF HEADER.DBF (RENAMES THE COPIED DATABASE BACK TO ITS ORIGINAL NAME)

TYPE EXIT TO GO BACK TO ALPHA

THEN UPDATE THE INDEX OF HEADER.DBF

IF THE DATABASE HAS BEEN RESTORED, YOU CAN GO BACK TO DOS (ALT F9) AND DELETE THE CORRUPTED DATABASE.

DEL AHEADER.DBF

Back to Windows Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums