community.borland.com

Article #25078: Object In Use error when adding a foreign key

Problem:
Getting the error "unsuccessful metadata update -object  is in use"
while adding a foreign key with more than one connection to the database.

Solution:
IB V4.x

Modifying metadata like altering tables of an existing table require exclusive 
access to the database, therefore only one connection to the database is
allowed.

Last Modified: 23-SEP-00