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
 
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

Access wants password to SQL Server 1
What are the steps to fix damaged MDF files in SQL Server? 0
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
SQL Server Backend is Read Only 7
Linked SQL Tables don't report Cascading Updates and Deletes 2
Relink of SQL Server tables in Access 2013 causes massive bloat 0

Back
Top