Accessing data from Act Professional for Workgroups 8.0?

The ACT! instance is called ACT7

Do you want to read or write to the ACT! data?

To Read, you can use OLEDB or ODBC. To write, you can only do this via the ACT! SDK

For all the methods, see:
http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html

Sorry, I meant ACT7, not CL7. Not sure where I got that from!
Had a look at the linky, and the only useful information that presentation seems to give me is "requires programming in .Net".
That's exactly what I want to do, but the presentation doesn't seem to give specifics about how in .Net I can get to the data.
If I knew the SQL login, I could probably get the data I need.
I only want to read from Act, not write to.
 

If you only want to read from ACT!, then you don't need .Net - you can do this with OLEDB or ODBC

Maybe this will give you some more help:
http://blog.glcomputing.com.au/2009/04/getting-table-structure-and-links-from.html

I don't know the password, and that article describes how to reset the password, but...
I don't seem to have the ActReader.exe that it refers to, and I'm unsure about changing any passwords, as it suggests. We have many users using our Act database, and I don't want to go and break an existing and working system for many users.
I wonder if I don't have ActReader.exe because our version of Act is so old?
If I could achieve what is shown in this article:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=22989
...I'd be on my way, but I just don't know the login ID and password, and don't want to reset it either.
Surely there's a setting somewhere (perhaps in the registry), that contains some kind of connection string, so that I can extract the password from it?
 

HI,

Unfortunately there are not so many solutions for ACT...
but you can try here by posting your query again...

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_alp.php?p_sid=9FJ7xAPj&p_lva=14150&p_li=&p_accessibility=0&p_redirect=&p_new_search=1&p_search_type=answers.search_nl&p_sort_by=&p_page=1&prod_lvl1=6512&p_pv=1.6512&p_prods=6512

Regards,
Abel

ActReader didn't come with ACT! till 11.1

In that KB article JimR123b, have a look at the bottom - there is a link to download the ActReader.zip and the Guide to use it

The answer was provided

The guide for ActReader seems to only provide instructions which either use a known password (which I don't have), or to reset the password (which I don't want to do as other users are accessing the system).