Hi Nancy,

>>The entire database is in fox 2.x format so any reindexing done by VFP needs to be backwardly compatible.
>>It also orders the tables into their natural PK order to aid rushmore (hence the reason for the select statement).
>
>Why not use the sort to command?

Why do I get the feeling that if I had used the sort to command you would have suggested I use the select command instead?
My preference is always to use "select * from order by" type syntax.. I feel the VFP team will have concentrated on the more modern commands - I tend to avoid the older legacy commands where there is a newer alternative.

>But by the time you try to use close the table, you've said you have other errors that should be addressed. Question, why do you structure your USE IN command as you do? Why not just "USE IN MyAlias"? I doubt that's a problem, but it is convulated, and given a strange, weird, hard-to-diagnose bug, making code as straight-forward as possible is helpful.

USE IN Select('tablename') is a much more resilient way of saying USE IN tablename
It will not generate an error if the table is already closed which I find helpful.
but... if the code above is functioning correctly this would never be an issue.
The problem is that I want tolerance in this routine - I want it to carry on even if it finds a problem with 1 table or index.

>
>The primary reason I wouldn't overwrite the original table until I'm sure I've recreated it.

I Agree... but its kind of difficult to predict this kind of issue before it happens

>The place to start, IMHO is "There is not enough memory to complete this operation." And the best way to tackle it, in this case, is step back from the routine and see if it could be restructured to avoid questionable situations. It's just simpler in the long run, I've found, that patching things with spit-and-baling wire as my Dad used to say.

Again I agree.. the only problem is that this routine was an attempt at exactly that :(
I cannot really see a way to improve the actual theory behind this.. all I can do is to add more integrity checking. unless you have any suggestions?