At 08:48 AM 13-11-02 -0800, you wrote:

>Hi all,
>
>I can't create foreign key constraints on a table. The error said that the
>object is in use. But no one use the db. I am sure about it. We're still on
>the development stage.
>I'm using IBAccess and IBConsole, but still can't do that.

If you are using IBAccess etc. then someone *is* in the database: you. If
you can, close all inquiries on database objects and complete all
transactions...then try your DDL statement in clear water.

I don't know whether IBAccess and IBConsole are capable of closing
everything down (not saying they can't, just don't know if they can...) If
you need a tool that can do this, grab IB_SQL from
www.ibobjects.com. Don't open the browser; and before you run your DSQL
or script, go to the Transaction page and commit any transactions pending
there, by clicking on the folder-like icon with the tickmark on it.

heLen