Password application in TransferDatabase A97

[Kahuna]

Hi Folks

I am using Transferdatabase to link to an outside Db which works fine. I'd
like to use a password on this external Db too, but currently I can find no
way to save the password in the code to avoid the operator having to
manually input it (as in an ODBC Connection).

My string is:

DoCmd.TransferDatabase acLink, "Microsoft Access", DB_Path & "Filter.mdb",
acTable, "condition_filter", "condition_filter", False, False

I know the last argument suggests no pass word, but if I set it to true -
where does it expect to find the password data?

Help Appreciated

Cheers