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

Posted on 2007-10-02
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 100

    Accepted Solution

    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 42

    Assisted Solution

    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
    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 -

    2. OLEDB - see

    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 - It'll make you life easier and it has a bunch of CRW reports that you can customise built in

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now