9tanstaafl9
Well-known Member
- Joined
- Mar 23, 2008
- Messages
- 535
Hi there, thanks for looking at my issue. I think it's a simple question but I'm a newbie with regards to ODBC.
I have a workbook that has multiple queries, each on it's own tab. When I run the report my macro refreshes all the queries, and it makes the user enter their user name and password more than 10 times.
I would like to do one of two things. EITHER make it so that when the ODBC window pops up to request user id/password that I only have to have them enter it once, OR find out if there is some way to have my macro collect this information at the beginning and store it somewhere where the ODBC connection can get to it. Either way is fine.
Every time I looked this problem up I found answers that just said to click the SAVE checkbox to store the password. This is not an option for security reasons. I do want them to have to enter their password, but since it is the same for all the queries it seems ridiculous to have to enter it multiple times.
Again I know almost nothing about ODBC/connection strings etc. I managed to get it to work previously through trial and error, and our old database didn't have security, I only needed to get the path right.
Here is what it looks like now (Excel 2010):
I have a workbook that has multiple queries, each on it's own tab. When I run the report my macro refreshes all the queries, and it makes the user enter their user name and password more than 10 times.
I would like to do one of two things. EITHER make it so that when the ODBC window pops up to request user id/password that I only have to have them enter it once, OR find out if there is some way to have my macro collect this information at the beginning and store it somewhere where the ODBC connection can get to it. Either way is fine.
Every time I looked this problem up I found answers that just said to click the SAVE checkbox to store the password. This is not an option for security reasons. I do want them to have to enter their password, but since it is the same for all the queries it seems ridiculous to have to enter it multiple times.
Again I know almost nothing about ODBC/connection strings etc. I managed to get it to work previously through trial and error, and our old database didn't have security, I only needed to get the path right.
Here is what it looks like now (Excel 2010):
Code:
DSN=Visual FoxPro Tables;UID=;SourceDB=PATHGOESHERE;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;
