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…
