The program I suggested does indeed attempt to compile a database. That may or may not be what you want. For example, you might have stored procedures in the database that need to be compiled.
If that's so, the solution is to make sure the database is closed before you do the compile. And the way to do that is to
close the project first. As long as the project is open, there is a chance that any databases contained in the project will also be open. That's because the project has to know which tables (and views, stored procedures, etc.) are contained in the database.
So, close the project, then do CLOSE DATABASES ALL in the command window, then run the utility.
Alternatively, you can avoid compiling the database by making a simple change to the utility. Around line 70, you will see the command to compile the database. Simply comment out that line.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads