Hey peoples. I've got a VB6 app and I want it to open a database. I've got the database locked with a password. I have a bunch of users each with his own table inside the database. I have a password for each user stored in the database.

At the moment the program has a hard coded password it uses to open the DB then it asks the users for a PW and away we go.

But that's not very secure because anybody could read through my EXE and find the password. What's the best practice? I'm thinking I should store a hash of the user passwords inside the database and use that to authenticate the users but here's the question... how do I keep the DB password secure so the EXE can open the DB???

Any suggestions appreciated.