>>How can I close a specific database only?
>>CLOSE DATABASE FileName
>>Doesn't seem to be a valid command.
>
>CLOSE DATABASE ALL is the only thing I came up with. Ain't it terrible that you can't close a single database. I hope someone else has a better solution.
CLOSE DATABASE cDatabaseName is not valid.
CLOSE DATABASE ALL closes everything and puts you back in work area 1.
What you want is two commands back to back:
SET DATABASE TO cDatabaseName
CLOSE DATABASES
CLOSE DATABASES without the "ALL" addresses the current database.