I am trying to find a way to link my online sql database to my local ACT! database. Anyone have a solution to this? I need for clients to be able to input information and sync it with the local ACT!. Also need to be able to pull the info from act and display it on the web.
Unfortunately, ACT! out of box is not able to connect to a sql database as you have described. You may be able to accompolish this by using the SDK package which you can find here: http://www.act.com/partners/addonpartners/index.cfm
Also, I was able to find a third party addon that seems like it would allow you to do what you want. You can find information on the addon at this link: http://www.act.com/products/solutions/company/index.cfm?TYPE=comp&SID=53