can any one do me a favor and tell in steps what should i do to solve this problem:
i finished my database and connected it to VB 2005 code and it works great,but now i want to make the access to it by user name and password .so i created anew login in my server.. now i want to
1-encrypt the database or i don know just make it closed when it's transfered to the client computer
2-make the code access the server or the database through this login account only
3-make the client through code only execute procedures in database and nothing else.......
so how to make the whole story work