Save password in DSN

[brainy]

I have an Access app that exports data from MAS90 to a text file. I have it fully automated except one thing: the MAS90 authentication always pops up asking for company name, user ID, & password. How can I embed this in the ODBC connection?

 

[BigLouie]

You can do this one of two ways. First you can create a silent DSN. Enter the log in information there. Or you can use SQL Specific Pass Through Queries in Access and code in the log in. I like this better than linked tables because it returns data twice as fast and allows you to code in the log in.

 

[brainy]

Thank you. The Silent mode in the DSN worked. That is the quick solution, but evidently not the fast solution. Now I'm curious about why the pass-through query would be so much faster. Is this always the case when compared to ODBC linked tables, or just with the ProvideX ODBC driver?

 

[BigLouie]

It is always the case with linked vs pass through. Any good Access book will explain why.

 

[brainy]

Thank you very much.