>>>>>>>I am getting index does not match the file - is there any easy way of finding our which file that is - it is a very large system with masses of files
>>>>>>>
>>>>>>>Thanks
>>>>>>>
>>>>>>>Colin
>>>>>>
>>>>>>No easy way, other than opening the tables one by one. If all the tables are in the same folder, you can easily create a program to do this with Sys(2000) in a loop.
>>>>>>
>>>>>>If the system had a proper error handler, it would have shown you which table it was, since this error will appear on the line where you open the tabl
>>>>>
>>>>>Any chance you could give me a quick program checking all files in j:\global
>>>>
>>>>This simple program will give an error message if opening a table fails, and if you don't have an error handler active. Nothing advanced, I wrote this program in a few minutes to comply with your wish.
>>>>
>>>>

lparameters tcDir , tcSkeleton
>>>>if empty(tcDir)
>>>>   tcDir = 'data'
>>>>endif
>>>>if empty(tcSkeleton)
>>>>   tcSkeleton = '*.dbf'
>>>>Endif
>>>>tcSkeleton = forcepath(tcSkeleton,tcDir)
>>>>llFirst = .T.
>>>>clear
>>>>do while .t.
>>>>   if llFirst
>>>>      lcFile = sys(2000, tcSkeleton)
>>>>      llFirst = .F.
>>>>   else
>>>>      lcFile = sys(2000, tcSkeleton, 1)
>>>>   endif   
>>>>   if !empty(lcFIle)
>>>>      lcFile = forcepath(lcFile, tcDir)
>>>>      use (lcFile)
>>>>      ?lcFile
>>>>   else
>>>>      exit
>>>>   Endif
>>>>Enddo

>>>>
>>>>Please note that I am not sure that an index corruption will always raise an error.
>>>
>>>Thanks but I get unrecognised command verb on the line lparameters tcDir, tcSkeleton
>>
>>I don't. Which version of VFP do you use?
>
>I was trying to specify the directory this caused the error - my files are in j:\global how do I specify this in the code

The first parameter is tcDir, should give you an idea... :-)