ODBC Connection

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
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.
 
Back
Top