05-06-2009 09:31 AM
05-06-2009 10:02 AM
05-06-2009 10:04 AM
05-06-2009 10:47 AM
05-06-2009 01:17 PM
I have a question for you.....I'm not sure if this user ordered the wrong product or not, but here is what we want to do:
- Install ACT!2009 on a networked server and have a central database containing all our customer info
- Install the ACT!2009 client on 5 workstations that will all use this same database and be able to modify it.
I think that should be possible with ACT!2009 Standard, no? I've installed it on the server and created a new database. However when I go to install it on a workstation, it still goes through installing SQL Express and creating a new database, etc...How do I install the client on the workstations and point them to the database on the server? Thanks.
05-06-2009 01:40 PM
Have the database shared on the server and then each workstation can browse to the server and open the shared database. You can't avoid installing MSSQL express on each workstation. You could uninstall it after the initial install but that will make ACT! slow to open and then they would not be able to have a local database. You didn't indicate how many licenses was purchased but ACT! requires a separate license for each named user.
In my opinion, the user did order the wrong version. The standard version has a user limit of 10 and that can't be expanded. Also, if they get the premium version instead they may be able to have it use the MSSQL standard on the server on the server rather than the express version.
05-09-2009 03:56 PM
The Premium versions of ACT! can use your full SQL 2005 on the server as per this ACT! Knowledge Base article -
If you don't have Premium, there is no problem with Express and standard versions of SQL 2005 on the same system.
On the workstations it will always install SQL 2005 Express as it needs it for some local functions like email.
For some tips on the network install you might have a read of this: