If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access wants password to SQL Server
Hello, folks
I have an ACCESS Application which has linked table to SQL Server. When I first time open access database and try to open any table it asks to me enter the password to SQL Server (we use SQL authof not trusted) It is happening only for the first time. I have been trying to remove the table and then import from SQL Servern but it will be happened again after closing access. Thank you |
#2
|
|||
|
|||
Access wants password to SQL Server
If you use DSN (SQL ODBC drvier) to establish the Linked Tables, then you
can put the SQL Authentication into the DSN. -- HTH Van T. Dinh MVP (Access) "Uri Dimant" wrote in message ... Hello, folks I have an ACCESS Application which has linked table to SQL Server. When I first time open access database and try to open any table it asks to me enter the password to SQL Server (we use SQL authof not trusted) It is happening only for the first time. I have been trying to remove the table and then import from SQL Servern but it will be happened again after closing access. Thank you |
Thread Tools | |
Display Modes | |
|
|