Connecting from Hyperion Intelligent Client to a secure Access Database (User Level Security)
Posted on 2006-06-02
I've developed a database where I have implemented User Level Security. I can open the database fine and the workgroup security is working fine. However, I have users who want to access the database via BRIO (otherwise known as Hyperion). I created a system DSN ODBC connection. In this connection I set up a user name and password to open the database. I've attempted to create an OCE connection to the database from Hyperion via this ODBC connection but I am unable to access the database. I get a message stating that I have no permission to enter the database. I've had little experience with Brio, but I would think that I should be able to access a secured Access database from Brio. Any ideas or pointers. I wasn't sure where to place this question and so I hope I placed it in the correct area.