09-15-2009 07:00 AM
09-15-2009 07:59 AM
Are you sure of your ACT! Version? What does the version say via Help|About ?
ACT! 2005 uses MSDE / SQL 2000 and is not compatible with SQL Express / SQL 2005. Only ACT! 2007 and above use SQL Express / 2005 where Service Pack 3 would be applicable via ACT! Knowledgebase article #21104.
09-15-2009 08:13 AM
09-15-2009 08:54 AM
Sorry, it's version 7
OK, here's an update with new information I found (sorry, I'm fairly new to ACT!)
Existing PC's are running version 220.127.116.11 with SP3 build 8.00.818
New PC is running version 18.104.22.168 with SP3 build 8.00.760
I've run the ACT update several times on the new PC but it will not update to 22.214.171.124.
The problem: I'm trying to connect remotely to the database on an existing PC and it tells me "ACT! requires at least service pack 3 of SQL Server"
Are the version differences the problem? What should I upgrade?