Subject Re: object is in use error while adding foreign key
Author csswa
Hi Amrita,

In addition to Bill's answer, keep in mind that you may have phantom
or existing connections via the IB tool you are using. Whenever I've
received this message using IBExpert, I've discovered that there was
some other transaction in another window (MDI interface) that I'd
forgotten to commit, or some other existing connection to the db. As
stated, some metadata changes require exclusive access to the db.

If in doubt, use a tool that reports the number of connections to the
db. If it reports more than one then you'll need to track down and
kill the others.

Andrew Ferguson
-- If they could bottle Andrew, they probably wouldn't.

--- In ib-support@y..., Amrita Chaudhury <achaudhu@s...> wrote:
> Hi all,
> I am trying to create a new table through my application and add a
> key reference to
> an existing table.
> I am getting the error - metadata update unsuccessful - objet
> [existing_table_name] in use.
> Can anyone tell me whats happening here , please?
> None of the other connections are being used to query/or update the
> table!!
> Thanks in advance !
> amrita .
> [Non-text portions of this message have been removed]