>I want to have a program that re-inexes all the tables. I set exclusive on and then close all tables. Then I open each one exclusive and issue a reindex command. I get the message that the file is already open & it isn't open exclusive. What should I be doing?
>
>
>Thanks.

Instead of checking the tables, try to get exclusive on the database. If you can't get exclusive, someone else has the database open. If you get it, do your
indexing. One bit of thought here. I used to use reindex too, but one day if an index goes corrupt, reindex won't help. You might try either DIRT as suggested here in the files section or it is easy enough for you to trap the the info to an array and then do a delete tag all and index instead of reindex.

Steve