I have an Access database with tables linked via ODBC to the corporate SQL
Server database. I use the Access database to perform custom queries and to
extract custom report from SQL Server. I have not any privilege to store
views on the SQL Server.
I set up an ODBC file data source (Control Panel -> ODBC Data Sources) that
connects the SQL database using the SQL Server authenticathion with Login ID
and Password entered by the user (not Win NT authentication). In this way I
can use Access as "custom queries container".
Does anyone know if there is a way to store the Login ID and the Password
without having to type them manually every time? Without saving my
credentials I can't even use the Access queries from third applications
(two-tier architecture in which Access works in the middle as data
pre-aggregator). If I try to connect an Access query via ODBC from a third
application I get an ODBC error (becuse the queryes are based on linked
tables requiring the Login ID and pwd).
Consider that I'm more an end-user than a programmer. Does anyone can give
me an advice?