Included as part of Sage ACT! Premium, the ACT! Reader account provides read-only access to most of the data tables within a Sage ACT! Premium Database. ACTReader is actually a user account in the ACT7 instance (Microsoft SQL Server) that you may leverage to access your Sage ACT! database from programs other than Sage ACT!. To use this account successfully, you will need to assign it a password. In this week’s tip, I’ll show you how!
Configuring ACTReader Password
When you configure the ACTReader account, you are simply updating the password to something secure, yet memorable. After the password has been set, you may use the ACTReader account and password credentials to connect to a Sage ACT! database from third party programs such as Microsoft Excel, SAP Crystal Reports, or Microsoft SQL Server Management Studio. To configure the ACTReader password:
1. Browse to:
64 bit Operating System: C:\Program Files (x86)\ACT\Act for Windows or
32 bit Operating System: C:\Program Files\ACT\Act for Windows
2. Locate ActReader.exe and double click it
3. Click in the New Password box and type P@ssword or some other unique, but memorable password.
4. Press TAB on your keyboard to type the password again in the Confirm Password box
5. Press TAB on your keyboard to highlight the Reset button. Click Reset.
Your ACTReader password has now been set. After you have configured a password for your ActReader account, you may use this account to log in to the ACT7 instance of Microsoft SQL Server, and connect to the Sage ACT! database. Data connections may be created directly from other applications, or at the Operating System level in the Microsoft Windows Control Panel. If you are not sure how to create a data connection, consult the Help files of the application you will be using to connect, or stay tuned, and I will show you how to create data connections next Friday!