M
Mahidhar
HI
I am currently working on task of linking tables in MDB to tables in SQL
Server 2005 so that data storage can be shifted SQL Server.
I have created a DSN entry and using that DSN I have linked all required
tables from the SQL Server.I have choosen SQL Server security and provided
username and password during the creation of the DSN. At the end of the
creation process , I also tested the connection and found to be successful.
However, when invoking the application, Access prompts me for user name and
password. I also noticed that secured connection is selected in the prompt
though I explicitly selected "SQL server Authentication" while creating the
DSN.
Is there any way to avoid this dialogue apearing every time?
Thanks in advance!
Mahidhar
I am currently working on task of linking tables in MDB to tables in SQL
Server 2005 so that data storage can be shifted SQL Server.
I have created a DSN entry and using that DSN I have linked all required
tables from the SQL Server.I have choosen SQL Server security and provided
username and password during the creation of the DSN. At the end of the
creation process , I also tested the connection and found to be successful.
However, when invoking the application, Access prompts me for user name and
password. I also noticed that secured connection is selected in the prompt
though I explicitly selected "SQL server Authentication" while creating the
DSN.
Is there any way to avoid this dialogue apearing every time?
Thanks in advance!
Mahidhar