Hi,

At May 12, 2003, 11:03, christopher_e_hall wrote:

> wrote:
>> While trying to drop a foreign key relation I am getting the
>> error "object INDEX is in use".
>>
>> Could some body tell me why?
>> When will we get such problem?

> I came across this error once before because I had more than (1)
> active connection to the database that I was trying to modify. I had
> two different database admin tools open and everytime I attempted to
> drop the foreign key I received the same error you are describing.
> Make sure that you have only one connection to the database and then
> try again.

And sometimes, with only one connection, the error can happen. When
this happens, disconnect from the database, reconnect and try again.

It can mainly happen after dropping a foreign key from one table, and
then trying to drop another foreign key from another table, and that
both foreign keys point to the same master table and field.

As Christopher mentioned, make sure there's only one connection to the
database. This a rule that I apply when performing DDL statements, to
make sure to avoid those kind of errors.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)