Hello
I have the following setup:
ORACLE DB ==> ODBC ==> MS ACCESS ==> OLAP CUBE ==> MS EXCEL
The oracle db has a password and the access db has a password.
Everything works fine until I move the MS ACCESS MDB File to another location.
If I then try to create a new MS EXCEL sheet that uses a new OLAP CUBE, I still have to enter both password (oracel and access), but then I get a bold error message saying "Password invalid"
And the OLAP CUBE is not created within MS EXCEL.
If I move the MS ACCESS MDB File back to its original location everything works fine.
Please help
Olivier
I have the following setup:
ORACLE DB ==> ODBC ==> MS ACCESS ==> OLAP CUBE ==> MS EXCEL
The oracle db has a password and the access db has a password.
Everything works fine until I move the MS ACCESS MDB File to another location.
If I then try to create a new MS EXCEL sheet that uses a new OLAP CUBE, I still have to enter both password (oracel and access), but then I get a bold error message saying "Password invalid"
And the OLAP CUBE is not created within MS EXCEL.
If I move the MS ACCESS MDB File back to its original location everything works fine.
Please help
Olivier