Hi Andy,

> When I create a foreign key for a table I get the message that the
> object is in use. I have the message even if I reconnect.
>
> When I backup and restore or just rename the database then I can
> create the foreign key.
>
> I'm working with Fb1.5 rc6. I use the Database Workbench for DBadmin.
>
> Anyone experienced the same problem and/or can it be solved?

Do you create it from the Constraint Editor or the SQL/Script Editor?

Do you have one or more SQL/Script Editors opened when trying to
create the constraint from the Constraint Editor?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com