ODBC Connection

[Chris]

Hi,

In my Access application, I'm linking to some ODBC tables in a SQL database.
I want to avoid the user having to receive the ID/psw prompt whenever Access
first connects to one of the tables involved. How can I do this? I thought
I needed to establish a connection in code and pass the ID/psw in the
connection string, but don't know how to link that connection to the current
workspace.

Thanks.

 

[Tony C]

When you are at the stage of selecting the Tables to Link,
there is a Tick box entitled "Remember Password". Ticking
this Box will save the connection details within the
Access Database.

Tony C.