>I will write a vfp exe file to fix the database/table file on my client PC. The exe file must use command like 'VALIDATE DATABASE RECOVER', 'APPEND PROCEDURES FROM FileName', 'MODIFY DATABASE'. I know this command is allowed only in interactive mode, right? How can I solve the problem without installing VFP on my client PC?

Take a look at Stonefield Database Toolkit (SDT) http://stonefield.com/sdt.html.

>Also where can I get the list for all the command that is allowed only in interactive mode? (VFP5.0/6.0/7.0)

For VFP7 see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgtskremovingrestrictedvisualfoxprofeaturesfiles.asp