DSNless ODBC from Access 2000 database gets password not valid error

[hmyers]

We have converted an Access 97 database to Access 2000 on an XP
machine. The application uses a DSN-less connection:

adoConn1.Open "DRIVER={iSeries Access ODBC Driver};" & _
"SYSTEM=SystemName;DBQ=LibraryName,Libraries;" , sUserID, sPassword

This fails everytime with an error message saying "Password for
<sUserIdon server <SystemNameis not correct..."

The user enters their userid and password via a form created in the
Access 2000 database. The password field has a Password mask applied.
The form also has the references checked for DAO 3.6 and ActiveX 2.6.

Anyone have ideas?

Thank you

[Rich P]

Do you know what the project is connecting to? It sounds like some sql
db. You need to specify what your project is trying to connect to. Can
the Access97 application still connect to the back end? If you can
still reach the back end from the Access97 App then you can find out
what you are trying to connect to. You need to know this first. Then
we can work on the correct connection string.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[hmyers]

Sorry I am getting back so late. I forgot I posted this question.

I figured out that when we converted the Access database, the field
with the mask of "********" had been the culprit. Apparently, the
..Text property of the field was being passed to the connection as
"********" instead of the actual password. I had to change using the
..Text property to the .Value property.