Memo File missing or Invalid in VFP 6.0

Hello Experts,

I'm working on VFP 6.0 , where I need to update records in the User.DBF file. All the DBF,FPT,.. files are located on our production server.

To update the records, I copied the User.DBF file on to my local machine and try to update from the Visual FoxPro IDE through COMMAND window.

I get this error MEMO FILE  C:\Data\User.fpt is missing or is  Invalid.

Where User.fpt file on server is huge nearly 2GB. And I was googling and found that we can copy the same DBF file and rename it to .FPT.But nothing working...

Production  Issue URGENT!

Who is Participating?
pcelbaConnect With a Mentor Commented:
I am also interested in the link which recommends to remane DBF to FPT.

The FPT size can be reduced by PACK command obviously. Copy both DBF and FPT to the C: drive and issue following commands:



It should reduce the size. The copy operation is done due to the safety reasons.
You need to copy both user.dbf and user.fpt to your local machine in order for it to work. Both files are critical.
Olaf DoschkeConnect With a Mentor Software DeveloperCommented:
Where did you read you could use dbf renamed as fpt? wrong assumption. Copy both files, there is no other way.

Bye, Olaf.
ASPDEVAuthor Commented:
Thanks for Sharing info.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.