>Hello All -
>
>I have created a database with one parent and four child tables, all linked together. Previously I ran Clean Up Database and then successfullly created referential integrity rules using the RI builder.
>
>Now that I want to edit the RI, I am getting a message that I need to run clean up database again. The problem is, that the Clean Up Database command is dimmed in the Database menu and nothing I seem to do will get it selectable.
>
>Any ideas?
>
One gotcha with the DB is that you can not open the DB exclusive just by re-issuing the OPEN DBNAME EXCL if the DB is already open. It does not work like tables where if a table is already open and issuing the OPEN MYTABLE EXCL will close the table then reopen the table exclusively. You have to close the DB first, then issue the OPEN DBNAME EXCL.
Mark McCasland
Midlothian, TX USA