I have almost completed an application using VB Express 2005 that connects to a SQL Express 2005 database. This will be a single user environment. I want to password protect the database so that the application (which will know the password) can connect to it but if somebody copies the database from the application directory and tries to open it themselves, they will need the password to do so. Using VB 2005 I cannot find a way to add the password to the database.

Once I add the password to the database, do I simply need to modify the connection string with this password so the application can talk to the database without being prompted for a password?

Thanks.

Greg