To create a connection object via code using a current DSN and supplying a username and password is straightforward.

When a form is opened (linked tables via ODBC) the DSN Configuration opens prompting for a username and password.

How do I use a previously acquired username + password and prevent the user seeing the configuration dialog box when a user opens a form for the first time?

Thanks in advance.