Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Closing a database
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00378329
Message ID:
00378408
Views:
24
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform