You can use sp_change_users_login system stored procedure. See BOL for details.
>
>I'm just inching along here.
>
>Ok, so I got the MSDE installed on the client computer I detach the database from my development machine and attach it to the MSDE instance on the client mahcine.
>
>Now when I try to access the data on the client machine using the same user name and password it won't connect.
>
>The user in my database is not listed in the "Security" section of the client SQL Server instance. Does this need to happen? How do I remedy this?
>
--sb--