Hi all,
There is something that doesn't work the way I expected about security when imlementing SQL Server 2000 .
The question is : how do I "hide" the data behind the passwords when working with Remote Views ?
The solution would be to send the passwords in SQL PassThrough commands. But , to have a user-friendly interface and for rapid development reasons, I should work with Remote Views. In this case , how could I send the password ?
To work with the database, first I create a DSN connection in ODBC . I can't put the password there, because someone else could use it to access the DB.
Then I could make a connection in Visual Fox and connect to SQL BD using that connection in Visual Fox. But , once again, when I create the connection, someone else in the LAN can connect to my DBC and use that connection (with password). So, what solution can I have to hide the password ?

Thank You very much in advance,
Mihai .