Cached Passwords IN Win2K
We have just rolled out Windows 2000 into our environment and there is a problem: In the previous systems, some team members used NT 4.0 with Access 97. They would build reports that used Oracle tables - and when they constructed the db's, the program would ask them to provide the username/password for the oracle tables and a check box to save it...if you check the box - the password is saved and everytime you run the report, you are not asked to provide the username/password for the Oracle tables. There was no security built into the Access files themselves...
So now in Windows 2000 (and Office 2000) - even though we check the box to save the passwords...it does not. Consequently, everytime the report runs (hitting any of the Oracle tables located on a different server), it prompts for a password for every Oracle table it needs...and there are several...
I am thinking this is a Windows 2000 security issue perhaps??? Is there a checkbox that we need to find...a registry issue thatwe can change....Give me a clue...