I tryied this way but without success and the same error message...
The database is located remotely (not local)... there are many users using
this table at this moment.. can this be the cause of my problem?

> I have run into this many times myself. It always ends up being there is
> a
> transaction that has not been committed.
>
> If you are viewing the data in a table through IBExpert then a transaction
> has started. You can rollback or commit this transaction by clicking on
> the
> x or the check mark at the top of the tables page. Once you are sure all
> your transactions are committed you should be able to add constraints.
> Logging out of the database has the same effect. Todd.
>
>
>
> _____
>
> From: daniel@... [mailto:daniel@...]
> Sent: Tuesday, October 26, 2004 11:56 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] New constraint in ibexpert...
>
>
>
> Hello everyone...
> I'm trying to create a new contraint using IBExpert but it always return
> that the object TABLE is in use. It's necessary to shutdown the
> database? How can I procede?
> Thanks, Daniel.
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
> <http://us.ard.yahoo.com/SIG=129676qdj/M=315388.5529720.6602079.3001176/D=gr
> oups/S=1705115386:HM/EXP=1098899828/A=2372354/R=0/SIG=12id813k2/*https:/www.
> orchardbank.com/hcs/hcsapplication?pf=PLApply&media=EMYHNL40F21004SS>
> click
> here
>
>
>
> <http://us.adserver.yahoo.com/l?M=315388.5529720.6602079.3001176/D=groups/S=
> :HM/A=2372354/rand=991100425>
>
>
>
> _____
>
> Yahoo! Groups Links
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>