calenger
02-01-2006, 10:02 AM
Hi All
I have an excel sheet using ado to connect an sql server. I have had to hard code the username ans password and was wondering if there is a way to stop user from opening the vba editor. thus allowing them to see the app account user name and password. Or if there is a better way to allow access to the users. The user accounts do not have access to the sql server.
Thanks
I have an excel sheet using ado to connect an sql server. I have had to hard code the username ans password and was wondering if there is a way to stop user from opening the vba editor. thus allowing them to see the app account user name and password. Or if there is a better way to allow access to the users. The user accounts do not have access to the sql server.
Thanks