01-07-2012 05:42 PM
I am now happily using Access to produce custom reports via the ActReader.
However, each time Access requests live data from SQL the server asks for the ActReader password. This is not a major problem except I have a couple of reports I would like to schedule for email distribution.
Is there a way to have the system save the password so it is not neccessary to input it on each use?
01-09-2012 06:53 AM
If you create the tables as linked tables, on the right hand side of the window where you choose the table, there is a check box to save the password. This is unfortunately not an option on the import objects window.