have you tried to shut the db down using:

gfix -shut -force 0 -user XXX -pass YYY c:\.....

--- In firebird-support@yahoogroups.com, "iguana_xyz"
<iguana_xyz@y...> wrote:

> Hello every one, I am adding a final touch to an application where
> when te user closes the application I want to copy the database,
> backup it and restore it, the problem I have is when i run the
> restore command I get an error that thhe database might be in use
>
> **
> lock time-out on wait transaction
>
> object C:\TINTORERIA_BASEDATOS\TINTORERIA_LOCAL.GDB is in use
>
> could not drop database

C:\tintoreria_basedatos\TINTORERIA_LOCAL.GDB

> (database might be in use)
> **
>
> I close teh database before executing the restore command but some
> how It still thinks that its open, what can I do to avoid that
> problem??
>
> Any Ideas??
>
> Thanks in advance