We have a Delphi2010 app running that accesses two .FDB Firebird DB
files for related data. We do backup and restore from within the running
program, using a Component Ace Compression TZipForge component. Prior to
restore, we use the TIBODatabase.Disconnect to free the FDB files so the
TZipForge component's ExtractFiles can over-write them. However, if some
other user is still running the app on the DB, the restore will fail.
So, I've been tasked to test if the file is open PRIOR to the restore.
Yet, using Delphi's FileOpen or Rename methods, my attempts to open or
rename the file fail, even though I am the only user. I'm running them
after the disconnect; yet because I'm doing it within the app, is that
what's messing us up? Any guidance would help...

Thanks
Lane Campbell
NW Software