trusted SQL SERVER connection

[IanT]

Hi

I am using code to create and relink to ODBC tables. Is there a way to set the 'use trusted connection' to yes by using code, as I have to manualy select 'Yes' each time the code is run!

 

[WayneRyan]

Ian,

If your connection string has:

Trusted_Connection=Yes;

you should be OK.

Wayne