Hello All,

Hope you can help with my odd ODBC connection, I have 40 companies that I pull data using pass-thru queries.  ODBC connection string is set up for each of the companies.  The retrieval process is stacked inside an Access Button object, when the Button is clicked, I see each pass-thru goes out to retrieve the data. Companies 1 thru 38 work fine.  However, companies 38th and 39th ask for my credential.  Basically, when it gets to companies 38 & 39, a dialogue pops up asking me to select company. Once company is selected and credentialed, it goes to server to retrieve data.  The kicker is, each ODBC string is set up exactly the same way for each of the companies.  Any insights or suggestions are greatly appreciated.

Thanks,