How to fix “Memo File is Missing/Invalid error” in visual Foxpro?

Published by Jacob Martin on March 7, 2015

DBF is becoming very popular among users due to its wide availability and acceptance. But sometimes created DBF file very easily gets corrupted all of the sudden. There could be many reasons by which a DBF file can be corrupted. DBF file is easily gets infected and sometimes it may get corrupted due to various reasons such as software malfunction, hard disk failure, power failure, malfunction in database application, virus infection, abrupt cancellation of DBF file and software or hardware errors. While opening a corrupt DBF file, the application may give you following error message.

“Memo File is Missing/Invalid”

Reasons behind occurrence of this error:

1. If one of the user performs an action that results in a table’s memo file being locked, and a second user attempts to open the same table and access the memo field information, the second client may open the memo file with an incorrect blocksize. This can result in incorrect information being read from the memo field or memo file corruption.
2. Either due to file corruption.
3. Another most common reason are the system crashed, or the user switched off the computer, while a table with a memo field was open.

Reasons are so many but these above mentioned three are most common reasons.There are lots of solutions of this error but here in this blog the best recommended and applicable process is discussed so take a look:

How to solve this error:

To solve this error issue try out this solution:

• Copy a valid memo file over the corrupt memo file to access the database again.
• Another solution is valid backup. If you have updated backup then you can easily handle this error by restore your all data from updated backup.

But If above if any case two solution does not work then you have another solution of using third party DBF file repair tool Software. This Software is very easy to use.

It supports dBase III, dBase IV, dBase V & MS Visual FoxPro 6.0, MS Visual FoxPro 7.0, MS Visual FoxPro 8.0, MS Visual FoxPro 9.0. Supports Windows 7, Vista, XP, 2003, and 2000.

This tool very efficiently recovers your corrupt database file without damaging any data. So if you are unable to access your database file then you can install dbf repair tool and recover your database file easily. This tool can also recover all components that included in a dbf file like column name, table name, and data types of all columns, Binary indexes, Indexes, primary key, candidate key, foreign key, unique key, and regular key.

Steps to Fix “Memo File is Missing/Invalid error” in visual Foxpro:

Step 1: Fisrtly you need to download, Install and Run DBF File Repair software.

Step 2: Then you need to select database application and database file to repair and then click on the ‘Start Scan’ button to start the scanning process.

Step 3: Then scanning process is in progress, if you want to stop it then click on ‘Stop’ button.

Step 4: Then you need to select the destination path by clicking brows button from dialogue box. And press ‘OK’ button.

Step 5: Then you need to select the database by clicking ‘Brows’ button in which you want to save the recovered data of DBF file. And click on ‘Finish’ button.

929 Total Views 2 Views Today