>>I got this error "Not enough memory for file map" when I tried to add a field to table structure. I got like 4 giga of memory. And I think the 3 memo fields in the table has something to do with the error. the FPT file seems somewhat having some corrupted data.
>>There are like 50 different tables in the Database. Only one table is giving me the error.
>>
>>I can't add field to or delete field from the the table. I tried PACK , it ran without problem. But I am still getting the error when trying to
>>add a field to the table. The table has 51 fields, record length: 484
>>Is there any way to clean up the fpt file ?
>
>One thing you could try:
>
>1. Backup all your database and table files (including CDX, FPT etc.)
>
>2. Copy all the data from the suspect table to a temporary one in the same database: COPY TO TempTable DATABASE MyDatabase ALL WITH PRODUCTION
>
>3. See if you can successfully modify the structure of TempTable. If you can:
>
>- Check that TempTable seems to have all the data
>- Make sure you have a good backup!
>- ZAP your original table
>- USE the original table, and APPEND FROM TempTable
>- Test to see if the issue with the original table is fixed
>- If so, remove the TempTable from your database
Hi Al, thanks for your reply. I just tried your method but I got the same error during the excution of the COPY TO command. It ended up getting a incomplete copy of the original table.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only