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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with connection to SQL Server 1
MS Access 2010 Web Application with SQL server 0
Best way to deploy Access read-only database that is linked to SQL tables 6
Linked Tables and SQL Server permissions 3
multiple odbc login screens 4
Relink of SQL Server tables in Access 2013 causes massive bloat 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Access 2.0 link to Sql Server 3

Back
Top