>Hi,
>
>I finally decided to experiment with the Referential Integrity Builder in my data base.
>
>Upon choosing that option from the menu, I get a message telling me that the Referential Integrity Builder cannot be used until my Data Base has been 'cleaned'.
>
>So I choose the option 'Clean DataBase' but it is disabled.
>
>Thinking it is an issue of exclusive use, I opened the Data Base in exclusive mode but still, the option to 'Clean Data Base' is disabled.
>
>Thinking perhaps a VALIDATE DATA would do the job, I executed that from the command window and it completed successfully.
>
>Still, cannot use Referential Integrity until Data Base is Cleaned but Clean Data Base is diabled!!
>
>What am I doing wrong this time ??
>
>Thanks, Ken
Try
SET EXCLU ON
before opening the DBC
I am not sure why, but I think that just opening the DBC EXCL does not ensure that the associated tables are being opened exclu.