unique way to hide username and password in sqloledb connection string

vba excel 2010

dbconnstring = "provider=sqloledb;Server=XXXXXXX.US.XCC.com;Database=Xdb_QA;Uid=xcx111;Pwd=sqlxxxx$;"

In a connection string like this is there a way to hide the uername and password from the user in case they get into the code ?
Thanks
fordraiders
LVL 3
FordraidersAsked:
Who is Participating?
 
COACHMAN99Commented:
better to hide/lock the code (via 'vba project properties / protection' tab)
0
 
nutschCommented:
Agreed with coachman99, or implement integrated security with your database server and setup users individually.
0
 
FordraidersAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.