SQL server login, ODBC link

[amigos]

I got database in which most of tables are linked using ODBC liks with SQL Server. Every time I open DB and I want to run any query or display table I have to login to server. Is there any way to do this with code so I can automate this and log on using VBA every time I open DB?

thanx for any help

Amigos

 

[Dugantrain]

Are you aware that you can specify your SQL Server UserID and Password in the Pass-Through Query's/Linked Table's Connection String? (No VBA required):

ODBC;DSN=Your_DSN;UID=Your_UserName;
PWD=Your_Password;MODE=Your_Mode;DBALIAS=Your_DB_Alias;

Not sure if this is what you're needing or not.

 

[amigos]

thanks for response Dugantrain,

actually I just relinked all tables, but this time I ticked "Save Password" option and it works.

I tried to do what you told me but linked tables are closed for edition, so where do I use this connection string you gave me?

Thanks again

 

[Dugantrain]

To specify the Connection String, open the Linked Table in Design View (it is here that you will get the 'Can't Be Edited' message). Go to the table's Properties and the first line, Description, is where you will specify this String

 

[amigos]

yes, I know
that's what I tried to do but after I change that (I go to properties and simply edit that string in Description field) and hit enter it changes to previous string anyway.

?