Defaulting ODBC User ID/Password 1

[demedic]

I use a form that contains a style number field. When the user enters a style number a style description field is automatically poplulated. The style description is obtained from a linked table that is actually a mainframe DB2 table. The first time a user gets a style description Access prompts him for a username and password. Is there a way to have the username and password automatically entered behind the scenes so the automatic prompt never happens?

 

[demedic]

For once the Microsoft Knowledgebase paid off! After browsing several pages and getting the gist of a couple different problem solutions, here is the solution I implemented:

Dim myDB As DAO.Database
Dim myTable As DAO.TableDef

Set myDB = CurrentDb()
Set myTable = myDB.TableDefs("CORPDB_MD_STYLE_TBL&quot
myTable.Connect = "ODBC;DSN=DB2A;DATABASE=;UID=User2040;PWD=Pass1"
myTable.RefreshLink

That does it! Hope this helps someone else.