HI, Thanks for the reply.

>
>When your app starts, you could ask the user for the user name and password necessary to access MSDE. These could be stored as memvars or application object properties while your app is running.

Yes, I'm doing so for test purpose (memvars). I also use SQLStringconnect to test it.

>
>To test if the user typed them in correctly, rather than storing the username and passwords themselves, store MD5 hashes of them. It is easy to test if MD5Hash(< user's name or password >) is the same as the previously stored hashes, but almost impossible to back-calculate the user name or password from the hash value.
>
>For more info check out Re: Hash() Function in VFP Thread #713481 Message #714561

Well, "To test if the user typed them in correctly" isn't what I want to do.

With VFP6 & Remote Views, I have to create a named connection with the User's real ID and Passwd (not the hash)in order to establish connection and perform MSDE´s SQL Authentication. Doing so, that info will stay in MyData.DBC while the app is running.


Thanks.