Showing results for 
Search instead for 
Do you mean 

Automating SQL password with ActReader?

New Member
Posts: 13
Country: Australia

Automating SQL password with ActReader?

Hello Everyone,


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?






Posts: 1,163
Country: USA

Re: Automating SQL password with ActReader?

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.

Matthew Wood
Act! SDK Support
Community Moderator