Thanks GT.
It worked.
>>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.
Work as if you don't need money
Love as if you've never been hurt before
Live as if this is your last day to live
Dance as if no one's watching