Hi Ann,

>Use the firebird configuration file to specify a different directory for
>temporary files?
>
>

Oops... overlooked that obvious one (guess its getting late).
While we're at it... any ideas why Firebird isn't using more of the
available RAM (I was hoping it would not need to use temp files... the
indexes should fit in RAM...).

brgds,
Jan