Hi Pierre,

I've been at PDC so I'm just getting to this message now. It sounds like your SQL Server is setup for Windows security. That means that you need to use a login of someone that has the appropriate rights on your server to work with the data. My guess is that "guest" does not have those rights. If working with a Web application, you can use Windows authintication or inpersonate a window's user. If writing a WinForm app then the person logged into the machine must have the rights.

>Someone said that the problem was in the Data Adapter code generator, so by taking the update command from the Update on the Users table directly and copying it for use on the view it works...
>
>Now my connection to the MSDE works fine but is using the Windows NT integrated security, thus I cannot log on from a shared drive as the "guest" login fails.
>
>If I try to change my login through the Visual Studio DE - and un click the Windows NT Integrated Security and put a user name and PW I get the following message:
>
>Login Failed for user 'Admin'. Reason: Not associated with a trusted SQL Server Connection.
>
>Do you know how to make this "Trusted SQL Server Connection" ?
>
>Thanks,
>
>Pierre