>I just tried opening the database before I went to the form (line before Do Form XX )and it STILL asks for password.
>
>I tried open datbase in the Load of the Form and then the Init of Form and it still asks for password.
>
>Obviously I must be doing something wrong.
>
>
>Any suggestions???

whoops, looks like i zapped most of my post before i sent, apologies.

Open the DBC and modify the connection used by the view. You can store the username/password here and under "Display ODBC Login Prompts", select "When login information is not specified." Since it's stored it will be specified.