>>As I understand VALIDATE DATABASE checks only Database and rebuild databases index, but it do nothing with tables in it.
>>
>>And I want to write universal function to fix database and tables (indexes) in it. But I don't know how many and which tables is in given database. Is there any function like ATABLES(), which put list of tables into array?
>>
>>Giedrius
>
>ADBOBJECTS("myarray","TABLE")

On a related note, I have a program which sends all DBF's in a directory to an array, uses them exclusively, and simply issues a reindex. However, I have recently had the indexes corrupted without reason, i.e. all indexes are deleted from the CDX.

The program runs on a Citrix WinFrame server (NT 3.51) while the DBF's reside on a Novell 3.12 server. Nothing has changed with the WinFrame nor the Novell server since the program successfully executed over a month ago. Have you encountered this before? Should I consider VREPAIR on the Novell server?

The last error message that I saw was a FoxPro error indicated "File Write Error". The network drive certainly was not write protected, and if the files were read only, how could Fox still delete all the index tags?

Thanks,
Jack Mendenhall
RMI