Hi Maria,
Few days ago we were in similar situation. My colleague tried to copy one directory and I issued even CLEAR ALL on my computer, and it still holded DataBase open. BTW, what does DBUSED('YourDatatabese') return? I left VFP and only this seemed to help in our situation. Weird.
Anyway, before doing zip, check DBUSED()
>According to the help documentation:
>
>CLOSE DATABASES [ALL]
>Closes the current database and its tables. If there is no current database, all open free tables, indexes, and format files in all work areas are closed and work area 1 is selected.
>
>Am I missing something else? I even tried a CLOSE ALL with no luck. The only thing that allows me to copy the database file is to do a CLEAR ALL after the CLOSE TABLES, CLOSE DATABASES ALL. But if I do this I lose all of my variables, menus, etc from memory.
If it's not broken, fix it until it is.
My Blog