ss7thirty
Well-known member
I have a problem. I have a scan application that needs the ability to Select, Insert, Update, and Delete records from a database. The way we have been giving the user access is by specifying a username/password in a configuration file. Is there a better way to go about this. Can this be accomplished by the program being “bound” with a “plan” to enable this. The plan would have more access rights than the individual. How can I go about this rather than hard coding the username/password into the code (worst option), or even just having it visible to the user in a configuration file located someone where in the "bin." This is a VB6 application so this may provide some extra hurdles but I believe that this problem can get solved on the SQL side of things.