access and linking tables

[cougartrace]

Hello all,

I have a situation where I'm using access to connect to DB2 os390 via DB2 Connect. On the OS390 side, I was required to change my password. However, in access I'm getting the error that it doesn't recognize my id or password when I try to link a new table. It doesn't even prompt me for my id or password. Somewhere it has stored my old password. Any ideas?

 

[KenReay]

Hi

Not familiar with DB2Connect, but is there somewhere in you code a "Connect String" set up, which gives location of db etc, including probably password and user id

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK