02-19-2008 02:40 PM
02-20-2008 08:38 PM
02-21-2008 06:25 AM
02-21-2008 09:24 AM - edited 02-21-2008 09:25 AM
In response to your original question:
When enough custom fields are created the table ‘fills up’ and the ACT! program creates ‘Overflow’ tables to handle the additional fields. I believe this is why some of your custom fields are listed in the TBL_CONTACT table and others in CUSTOM TABLE 0.
I think what Jason was referring to was the idea that rather than attempting to pull these entities on a SQL Table level. To retrieve the information you need at the SDK level through Contact method calls (programmatically).
I could be that you need the ActReader or ActPassword utilities that give you access to the Reader account in SQL or the ‘sa’ password for SQL respectively.
These can be purchased through Corporate Sales. If you'd like more information they can be reached at 866-421-7752.
Another option that you’d probably want to look at is the OLE DB provider that is available ‘out of the box’ with ACT!.
This would be a free option that might be able to retrieve the information you need.
This is our KnowledgeBase Article that details importing some fields to Excel - HERE
Ultimately, an ACC who specializes in ACT! reporting might be your best option.