I came from a SalesLogix background, where we had LAN workgroup users and remote users simular to ACT. The LAN workgroup users connected directly to the database located on a central office server hosting MS SQL Server, they didn't require a full version of SQL server installed on their workstations just the SQL connection software. The remote users synced to a sync server.
I have the remote ACT users pretty much worked out but I'm not sure I understand how the workstation ACT setup actually works. Do I simply copy the pad file to the users desktop from which it will make a connection to the SQL server on the main ACT server machine over the LAN? I have completed the full ACT Premium install on the workstation as per the workstation install guide and it installed SQL Server 2005 but as far as I know there is no database in that local SQL server and there shouldn't be because the pad file connects to the main database right ? hope my question is clear
Thanks Mike, from what you explained the main data for LAN users is stored and accessed directly in the central ACT SQL server, and if in use the ACT email info is stored in the local workstation SQL server instance. I also found the ACT premium whitepaper which clarifies the architecture a little more.