G Guest Jan 20, 2005 #1 i am using linked tables in access 2003, is it possibkle to store the password for the sybase odbc driver?
i am using linked tables in access 2003, is it possibkle to store the password for the sybase odbc driver?
G Guest Jan 20, 2005 #2 You can add a string value entry in the registry for the DSN you are using called password and set the value to the password.
You can add a string value entry in the registry for the DSN you are using called password and set the value to the password.
G Guest Jan 21, 2005 #3 Thanks for that works a treat. only problem is when i want to look at the linked table the dialogue box comes up asking for credentials that are already entered. i just need to click OK. How can i get rid of the need to click OK. Thanks
Thanks for that works a treat. only problem is when i want to look at the linked table the dialogue box comes up asking for credentials that are already entered. i just need to click OK. How can i get rid of the need to click OK. Thanks