Subject Re: MS Access ODBC to Firebird
Author Liz W
Sounds like you are experiencing this security feature, where the Firebird database password is not stored when you create the DSN.

http://blogs.office.com/b/microsoft-access/archive/2011/04/08/power-tip-improve-the-security-of-database-connections.aspx

Hope this helps,
Liz