Hi to all,
I have linked table to an external SQL server.
I am curenctly using an ODBC connection to access the tables, I would like to know how I can programatically make the connection without getting the dialog box asking for the password.

Thanks

Alain

Use Trusted Connection

oConn.Open "Provider=sqloledb;" & _
           "Data Source=yourServerName;" & _
           "Initial Catalog=yourDatabaseName;" & _
           "Integrated Security=SSPI"

Hi Jemmac,
can you explain to me more about the Trudted connection ??
I am new at this
Also I tried you code and it gives me an error at
oconn.open
Method or data menber not found

Can you give me more explanation
Thanks

Alain

When you create your DSN you have an option to use two type of authentication, one is SQL server authentication and the other is windows authentication.

1. SQL authentication - use a SQL server login account you create in SQL login.
2. Windows Authentication - uses a windows login to SQL

You can use both types of connection when you have setup SQL to use mixed mode.

One question I did not ask; how are you calling your connection string.