I have SP1&2 installed and find that during developement I very often have to:

SET EXCL ON
USE XXXX.DBC
PACK DATABASE
VALIDATE DATABASE

to get my RI to function properly. Note that both PACK and VALIDATE are done what you select CLEAN UP DATABASE from the (end of the) DATABASE menu. The problem is that I almost always find that that option is greyed out so I have to run the operations manually.

I therefore suggest you try to PACK and VALIDATE (or CLEAN UP) your DB and see if that resolves the prob.

Hope this helps!


>Has anybody noticed that if you remove some persistent relations from your database, then regenerate RI, then try to delete stuff, it might tell you it can't find one of the RI programs, and the trigger fails? There appears to be bugs in the RI generator code that don't always clean up references. I usually have to put some relations back in, possible with triggers set to "ignore" in order to make it clear itself and go away.
>
>I just felt like grumbling. I haven't installed any service packs or looked for technotes.