Database Access

ACT! provides a number of ways to access the ACT! database for integration or reporting, depending on needs and access method.

Database Access via OLEDB Provider
ACT! includes an OLEDB Provider, which enables read-only access to a sub-set of database views. You can use the OLEDB Provider to integrate other applications with ACT!, for example, to use Crystal Reports® to generate custom reports.
Naturally, security is maintained using the OLEDB provider, which means that users can only see the data that they have the rights to see.

Reader Account
ACT! provides a read-only SQL Server login to its database instance. The Reader Account allows direct, read-only access to information in the database, bypassing the security checks on access rights. This access method is supported in ACT! Premium databases only and enables access to all ACT! Premium databases on the machine. This is machine-specific and you must contact your regional ACT! sales team to order this access.

SA Password
For those that need Administrator access to the ACT! database for reporting and server-side backups, an SA Password utility can be used to reveal the SA password, reset it, and gain Administrator access to the database. Like the Reader Account, this method of access is supported in ACT! Premium databases only and must be obtained through your regional ACT! sales team.