Hi,

I was wondering how to add a username and password to this connection string

Code:
 cmd.Properties _
 ("Jet OLEDB:Pass Through Query Connect String") = _
 "ODBC;DSN=Asset;UID=mengj;DATABASE=Asset;Trusted_Connection=Yes;"
Thanks

C19