>Hello all
>
>I'm connecting to SQL2000 table via remote view.
>But I don't want it to prompt me for login and password everytime I try to open the view.
>
>How do I prevent SQL2000 from asking for login and password?
>
>
>Thanks

Use a connection you've created when you create the view.