crystal reports requests password every time I start application
Posted on 2013-01-26
I am very new to crystal reports, and I am going to use it in an application I am developing. It is a c# 2010 winforms application that connects to an MS Access database which is password protected.
When I go through the process of adding a report (at design time), it requests the password and accepts it.. everything works as expected, I can select a query and produce a report based on that. Great.
But then at runtime, when I click a button I created to display the report, it requests the password again? yikes... why is this not stored in the connection details? Clearly I don't want the end users to be entering the password for the database...
Any idea how I can prevent this, I don't really want to remove the password from the database.