topic Re: How to restore index-FoxPro in Archive

How to restore index-FoxPro

archerfish — Fri, 06 Jul 2018 12:03:20 GMT

The fact is that we have a program that was written a long time ago, and do not even know who wrote it. Recently, an employee incorrectly closed it and the index flew off! Now, When you try to open the error index does not match database file. create index statements, please tell me how to restore?

Re: How to restore index-FoxPro

RyanJames — Fri, 06 Jul 2018 12:48:53 GMT

Hi Archerfish

Hope you are well!

Sorry to hear you are having issues with this - I myself admittedly wouldn ot have much knowledge of FocPro, but there are others on the forums who would have much more expertise. You may potentially find this thread helpful. Hopefully there is some information there that will help you sort this issue!

Regards

Ryan

Re: How to restore index-FoxPro

extremmum — Thu, 26 Jul 2018 11:52:13 GMT

As a variant try next step:

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
or you can try to use dbf repair , find this service here

Re: How to restore index-FoxPro

Diana-Farad — Tue, 01 Oct 2019 09:07:51 GMT

Thanks for this post! Very useful