>>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.