Connecting to Act through OLEDB (no Activities Table) 1

[gogopoppy]

Hi,

I'm successfully using CRXI with OLEDB driver for Act 2007 however the activities table doesn't seem to be one of the tables that gets listed. I can get to History and Notes etc but not this table. Sage software who own Act don't seem to have help on the topic on their knowledgbe base.

It used to be something we could report on old versions of ACT before they rewrote the application.

Does anyone have experience with this?

Thanks

G

 

[synapsevampire]

I found a blurb saying that you cannot export the data, sothat might be the samereason Crystal can'tsee it.

http://www.jltechnical.com/Exporter7/User Guide Exporter7.pdf

Also make sure that you have Views and SPs available in the database explorer.

-k

 

[gogopoppy]

Thanks

I've looked at this link. Very helpful

According to that doc there is an alternative to the OLEDB driver that costs more ($400 or so) called the Act! Reader and with this driver you can get the missing data that you need.

It also seems to be the case that Act! will now sell you the SA password - which would expose all the tables and that would be a third possibility.

So at least its possible if unnecessarily complicated.

G

 

[GLComputing]

This might also help with doing CRW reports from ACT! -

http://www.crystalclearreports.com/

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[gogopoppy]

I dowloaded the trial version of Crystal Clear Reports and its got some good parameterized crystal reports.

It also does something to expose the Activities table as an Access DB (those reports would have to be run through the added menu in Act.)

G

 

[GLComputing]

It uses the ACT! SDK to bring the activities into an Access file before running the report.

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au