Community
Showing results for 
Search instead for 
Do you mean 
Reply

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?

 

Cheers,

 

Kurt

 

Employee
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