""the_k_dubb"" <kevin@...> wrote in message
news:a2k9f3+pf1k@......

> I have tried everything to rid myself of this error, and I cannot. I
> am trying to create tables from my application as it needs them. What
> I am experiencing is that after a table has been used in a query,
> creating foreign keys, or dropping foreign keys to that table is
> unreliable at best.

> I have even gone so far as to disconnect and reconnect
> my connection before trying to alter the keys. I still receive the
> object in use errors, are there any other suggestions?

This is not the point. From the engine pov's, what counts is that the db is
detached and unloaded. This only can be achieved if NO connection is held to
the db, whether yours or from another user. All connections should be
terminated. Most GUI programs create more than one connection to work so
they trick the user thinking that there're phantom connections.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing