Help with connection 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
 
make a passthrough query against a table in SQL server
input ODBC;DSN=<yourdsn>;UID=<theUser>;pwd=<thepwd> in the ODBC connection
string (properties)
open a recordset against it in your startup routine & that should do it

HTH

Pieter
 
Back
Top