Printable View
First off, I am a total VB noob. I want to create a program so that I can store usernames and passwords. I want to be able to search by username and pull up their password. What VB program do I need to write this? Can I just use the VB in excel? This should be a pretty basic program, but I have no idea how to write it. Thanks.
Welcome to the forums. :wave:
I was going to suggest an Access database, but if you are more comfortably with Excel, you can use that too.
Automating Excel is a topic that is covered in our FAQ section.
If your interested in a web based solution the basic visual studio 2010 website template has a user / password logon page attached to it. Works pretty well.
Thanks for the tips. Any is fine. I just need something simple to use. I hate using spreadsheets to keep track of things, but I think it's unsecure. At least I can password protect it better and I think it would more organized in a database. I do have access on my computer and installed but not sure how I would create a database for this? Sorry, I'm a total noob
I have access installed but I don't have the slightest clue how I would set that up. Been years since I've even touched it. Any guides?
First up, what exactly does this mean?Is this for storing credentials that you use to log into web sites, etc, or is this a list of users for an application that you want to validate against? The two can be implemented quite differently because, in the second case, you don't have to store the actual password so it is inherently more secure.Quote:
I want to be able to search by username and pull up their password.
No. It will be a list basically. Basically a program that I can keep track of username and passwords for active directory. Makes it easy when I need access.
If you can use excel then why bother coding something?If you don't want to encrypt the passwords just use excel with protection (ah and keep the file out of sight).Everything doesn't have to be difficult.
The web based template asp.net application logon is secure. It gets put into a sql server and that is password protected because wherever you put it. it also will encrypt the passwords, but you can still look at them from sql server. If you don't have access to a sql server then it will use a file that you look in using sql server 2008
Web base login will only encrypt(and that if you specify it) your login password.
It will not encrypt the users passwords.
Do you mean you can add users to the database and they will be encrypted?
Yes that is an option but the OP must still use a control that will view the data,make a function that will insert users to the database thus playing with asp.net security,use authentication,Authorization, be sure to use an encryption key because hased protection will make the passwords unreadable thus he must play with the web.config and also be sure that to encrypt the web.config so the encryption key and the connectionstring would be unreadable.He must also make sure to decrypt everything on web.config if he decides to move the app in another server.
That is a long way to go and i believe that if the OP wants a simple user,pass list the excel is fine.