multiple id and password prompts on iSeries linked file

[dino624]

I am trying to print a report from access based on a linked file from an iSeries. I am prompted several times for an ID and password.
Can someone tell me why this might be happening?

[rpeare]

In most cases external data sources have a different userid and/or password than someone's windows login. So for instance if the database on the iseries (I'm assuming this is a reference to IBM's servers?) has a user name and pw for you of XXXX/YYYY but on your windows machine (the one with the access database) is AAAA/BBBB you're going to have a basic disconnect and every time you open the access database and touch a table it's going to ask you for a username/pw. If you were to leave the database open the whole time you shouldn't be prompted for the user/pw again but access 'forgets' every time you close the database. There are a couple of things you can do to avoid this

1. on your iseries create a username/pw that is identical to your username/pw on the windows side and use NT authentication in your ODBC driver
2. re-establish links with a username/pw when you open the database each time.

In either case the issue is that there's a basic disconnect on the username/pw between the server and your machine running access.