Access wants password to SQL Server

  • Thread starter Thread starter Uri Dimant
  • Start date Start date
U

Uri Dimant

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
 
If you use DSN (SQL ODBC drvier) to establish the Linked Tables, then you
can put the SQL Authentication into the DSN.
 
Back
Top