Loosing UserID and Password from ODBC connection.

R

Rob Diamant

Please help.

For some reason I am loosing my UID and PWD settings. I am setting the ODBC
connection as follows:

.....
With tbl
.Connect = "ODBC;DSN=SVR8;UID=sysadmin;PWD=sysadmin;APP=Microsoft Office
2003;WSID=ROB;DATABASE=Test2"
.SourceTableName = strTable
End With
db.TableDefs.Append tbl
Application.RefreshDatabaseWindow
End Function

If I check the .Connect property during this session it looks ok. After I
quit Access and recheck the .Connect property it now looks like:

ODBC;DSN=SVR8;APP=Microsoft Office 2003;WSID=USSTL-ROB2;DATABASE=Test2

The weird thing is, if I manually connect to the same table (and choose
"Save Password" in the dialog) everything is ok. Is there a property for
Save Password that I am missing?

TIA

Rob
 
Top