Very Computer

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?

Thanks.
Grig

use a connect string to connect to your SQL database which has the username
and password in it, and then save it in a text file or the Access database,
or even have it hard-coded.  Then, when you open the SQL database, use the
connect string and it will connect in the background, without the user
having to enter any information in.

gpt

Quote:> 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?

> Thanks.
> Grig