Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How can I connect to ACT! 2006 database from Crystal 10

Posted on 2007-10-02
Medium Priority
Last Modified: 2012-05-05

I was wondering if someone could help me to connect crystal 10 to an act!2006 database. The act database files are .pad or .adf (I am not sure). when I open crystal I have no Idea how to connect to act. There is an act folder in crystal however It only has .dbf datbase file extensions which I believe are from older versions of act.

Question by:badgermike
LVL 101

Accepted Solution

mlmcc earned 680 total points
ID: 19999146
According to this Act 2006 isn't supported.  That is probably because it didn't exist when CR10 was released.

The list for CR XI also doesn't show Act! 2006.

You probably need an updated database driver.  You may have to get it from Act!.

LVL 44

Assisted Solution

by:zephyr_hex (Megan)
zephyr_hex (Megan) earned 660 total points
ID: 19999424
we had to purchase something called ACT Reader from Sage in order to use ODBC to ACT 2006.

ACT Reader comes in two forms:  read only access, and read/write access.  we purchased the read only access.

when you install ACT Reader, it will take you through the process of setting up a password for a read only account.  Sage makes it seem like you have to then request 1 ACT Reader per machine that uses ACT.  this is not true.  you only need 1 ACT Reader and it should be installed on the computer that hosts the main ACT database.  you can then use that username and password on any other computer and configure Data Sources/ODBC (Microsoft SQL Server DSN) using the same settings that you used when setting up the ACT Reader.
LVL 30

Assisted Solution

by:Mike Lazarus
Mike Lazarus earned 660 total points
ID: 20004085
You can access ACT! 2005-2008 via two ways from Crystal Reports:

1. As zephyr_hex says... the ACTReader, which is READ ONLY access directly to the SQL engine of the ACT! database. This can be a bit confusing as there are many tables that have to be linked. You cannot write to the ACT! database using ACTReader. To get info on ACTRead, see - http://www.act.com/products/large/cl/services/index.cfm/

2. OLEDB - see http://tinyurl.com/3cznoh

For people look at doing work with Crystal Reports on the ACT! database, I usually recommend that they have a look at Crystal Clear Reports - http://www.crystalclearreports.com/index.html. It'll make you life easier and it has a bunch of CRW reports that you can customise built in

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month10 days, 23 hours left to enroll

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question