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
Help get this topic noticed by sharing it on Twitter, Facebook, or email.
see the change log
You may to handle by using internal procedures in Outlook Express.
To resolve this, try to rename the Pop3uidl.dbx file, and then restart Outlook Express. Follow these steps:
1.Click Exit on the File menu to quit Outlook Express.
2.Click Start, point to Search, and then click For Files or Folders.
3.In the Search for files or folders named box, type Pop3uidl.dbx, and then click Search Now.
4.Under Search Results, right-click the Pop3uidl.dbx file, and then click Rename.
5.Type Pop3uidl.old, and then press ENTER.
6.To start Outlook Express, click Start, point to Programs, and then click Outlook Express.
THIS RESOLUTION FOR SOLVING ISSUES WITH CORRUPTED DBX FILES,
BUT PROBABLY CAN HELP YOU TO VIEW DAMAGED DBX FILE.
The manual solution starts with finding or locating the corrupted DBX file(s). You need to start the Registry Editor to find the location where Outlook Express stores its files. Follow the steps given below to know how to do this:
• Press Win+R to open the Run window.
• Type regedit into it and press enter.
• The Registry Editor window will be opened. In the left hand side pane, expand the folders in this manner:
HKEY_CURRENT_USER > Identities > XYZ > Software > Microsoft > Outlook Express > 5.0
• Now in the right hand side pane, locate the Store Root settings from the list and double-click it.
• The path will be shown where Outlook Express stores its files. Copy the full path from there.
Once you have copied the path, you need to move the mailbox file(s). Follow the steps given below to know how to do this:
• First of all close the Outlook Express program if it is opened.
• Now paste the path (copied earlier) on your Windows directory and press enter.
• You can copy or move all the files from this location to a new location. After that, delete all the files from the original location if you have copied them.
In the third step, you need to import the DBX file(s) into Outlook Express. It would be easy for Outlook Express to import the file(s) without causing any trouble. Follow the steps given below to know how to do this:
• Start Outlook Express on your system.
• Click on File menu > Import.
• The Outlook Express Import window will be opened. Select the Outlook Express version in the list from which you want to import the emails. If you are unsure with that, you can select Outlook Express 6. Click on Next.
• Now click on Browse to select the directory where the files are saved. This is the very same directory in which you have moved the files from original location earlier. Click on Next.
• Select the items you want to import. For example: you can import All folders or the Selected folders. Click on Next.
Now start your Outlook Express and check your mailbox folders again.
This reply was removed on 2014-10-13.
see the change log
Copy a valid memo file over the corrupt memo file to access the database again.
NOTE: The original memo field information will be lost unless the valid memo file was an exact backup of the corrupt file. All memo field backup files have an extension of .TBK.
The corrupt memo file will have an .FPT extension, such as OLD.FPT. In the following example, assume NEW.FPT is a valid memo file. To bypass the error message and access the database again, type the following command at the MS- DOS command prompt:
copy new.fpt old.fpt
This is the guide how to recover .dbf file, see steps...
Open the dBase command line from the Windows Start menu.
Log into the local dBase software with your username and password.
Click on the dBase command line section of the window that is open.
Type "dbf /recover yourDbaseFile.dbf" into the command line, where "yourDbaseFile.dbf" is the name of the dBase file whose tables are corrupted.
Press "Enter." dBase takes some time (ranging from a few minutes to a few hours, depending on the size of the database) to analyze and repair the file and its contents. You are alerted when this process is finished.
Try opening the .dbf file in Excel or other program that supports opening the .dbf format.
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.