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.
Regards,
Wayne