>Hi,
>
>I recently made a change to the structure of a fox app i'm working on. Anyways, it changes the Referencial Integrity. I need to edit it but I am getting an error that says the dbc is not open for exclusive use. I tried setting excl on but that didn't work.
>
>Anybody have any ideas? Or will I have to delete the database all the tables and then recreate them all?
>
>Thanks,
>Chris
It happens to me all the time.
After issuing SET EXCLUSIVE ON, you have to re-open the database. Any database or table opened previously will not be affected by SET EXCLUSIVE.
SET EXCLUSIVE affects the default (EXCLUSIVE, vs. SHARED) for future DBF or database openings.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)