Access miss typematch and Sybase password

Access  type misssmatch error
join on different types
such as tbl_1
       LEFT JOIN tbl_2 AS counter
       ON tbl_1.nameID = counter.compID
Sybase  set password problem
there is no way for sybase set password in odbcmanger(odbcad32.exe)
so we need add password in dsn file or regedit. that can get a connection string include password