Versions des environnements
Network:
Windows 2000 Server
I did further research on the net, and talked to other resources. I finally was able to get the memo file fixed, I think.
I issued this select on each of the memo fields in my table:
select field1, comments1 from table1 where at(chr(0), comments1) > 0 into cursor csrNull nofilter
This showed me where I had corrupt memos and I could delete those memos.
I had 3 bad memos out of 5,400 records.
Then, I issued this command for each memo field in the table:
replace comments1 with null for len(comments1) = 0
After I did that, I was able to successfully pack the table, which (right or wrong) is what I was using for criteria to determine if my table was corrupt or not. It is now able to be packed.
I will be doing more testing today.
I believe the crash of the server was the cause of this corrupted table.
If anyone has additional input, I am interested in knowing.
Thank you for all your assistance.
Laurie
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement