Hi,

Creating FK constraints is documented as being able to if only 1 connection
is active to the database.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Can anybody help me here? FYI, I'm new with firebird.
> I need to create a FK constraint between tables. But I always got the

error message that say: "Object (tablename) is in use". But actually, nobody
access the table. Currently, there are 4 people who can access the db

> So far, this problem solved when I restart the db and no one allowed to

access the db first.

> What should I do to solve this problem?