Hello,

> Is there any way I can change the rdb$file_name in a fdb to point to
> another location.
>
> I have copied a multi file fdb to an other directory (temp backup),
> now I need to access it without closing down my current one, moving it
> and coping the old one back. (I know I should have gbak and restored,
> but I had to do the copy in a hurry, and I forgot about this table)

Actually, that table is just indicative. You cannot change it and
have your database working again.

Here's more info and a plan that might help you:
http://www.volny.cz/iprenosil/interbase/ip_ib_download.htm

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com