By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Hiding ODBC Credentials for Pass Through Query

P: 5
Hi All

I am currently building a Database which uses a passthrough query

The query queries a teradata database using an existing ODBC setup; inserting records into a temp table

I want to move the Access DBto a second PC which will automatically run it once a week

Our IT department changes the passwords of ODBC once every three months

Is it possible when setting up the initial connection within the VBA code to the Teradata warehouse to simply use the credentials within the ODBC setup where one can save the password. So in three months time, when i change the password in the connection on my PC...The code will use the new password without me having to go into it?

Thank you for your time
Mar 10 '14 #1

✓ answered by zmbd

Simple answer is no.
You can code to request the credentials as needed, and this is what I have done for MySQL/SQL-Server situations.

However, AFAIK, there is no way to automatically pickup and alter the passphrase.

Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,331
Simple answer is no.
You can code to request the credentials as needed, and this is what I have done for MySQL/SQL-Server situations.

However, AFAIK, there is no way to automatically pickup and alter the passphrase.
Mar 10 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.