Hi,

> In Access there is a command to compact the file. Is there an eqivalent in

Firebird?

No, there isn't. Firebird will re-use empty space inside the file for new
records. If
you really want to remove the empty space and continue using the same file,
the
only way to do it is to create a backup and restore the database.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."