Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I close a database?
Message
 
To
30/12/1997 13:00:58
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00068458
Message ID:
00068486
Views:
30
>Sometimes I run a form first thing into a session, which opens a database for shared use.
>Then I want to modify the RI and I get the message that the DBC is not opened exclusively, so I can't update.
>I can't figure out how to close the database so I can re-open it exclusively.
>I try "close database" with the database selected, I try "close databases all", nothing seems to be working.
>Is there something going on that is keeping the database from closing?
>I only have my project open at the time.
>
>TIA
>
>Bill

Bill,

First let me say that CLOSE DATABASE only works for the current database, that is the one that has been set to current with iehter the SET DATABASE TO command or the database combo in the standard toolbar. CLOSE DATABASE ALL does not close all dbc's, it closes all tables in the current data session.

Secondly the Project will open databases on you in the background, so before you MODI PROJ make sure set exclusive is ON. If you need to close the project, then close each database that is open. You can then, either OPEN DATABASE MyDBC EXCLUSIVE or SET EXCLUSIVE ON and OPEN DATABASE MyDbc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform