Best way to setup ACT with Desktops and Server (client install or RDP into Server)?

Hello, I am taking on a new client who is running ACT 2007 Premium workgroup. They have 10 users and the database is installed on the server. They only have 1 server (server 2003) so it acts as the Domain, DNS, DHCP, Printer and File sharing. It looks like the users are RDPing into the server to run the ACT program that is installed on their profile on their server. Is this the best way to run ACT? Or would it be better to install the client software onto each PC and connect it to the database file? Which method is the least intensive for the server and the network? I would think installing the software onto each desktop would be the best for the network wouldn't it? Also can ACT 2007 run on Windows 7 PC's that run the program in compatibility mode? Thanks!
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Normally, the best way is, as you suggest, to have the clients installed on each desktop and access the data on the server ... this also enables ACT! to connect to local copies of the Office.

However, ACT! 2007 cannot be installed in Windows Vista or Windows 7 ... for that, you'd need to upgrade to a current version of ACT!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bhodge10Author Commented:
what about running Windows 7 XP Virtual mode or whatever it's called? I'm trying to prevent the customer from having to upgrade his ACT program if we don't have to. He is in need of new PC's and would like to move them to Win 7 if possible.
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
I haven't tried versions that old in the XP-mode ... so, not sure
The old version you have also doesn't support Office 2007 or 2010 ... so that might be another consideration
Here's a link where someone else said they tried Act 2007 (v9) on Win7 in XP mode and it worked.

They said they used the instructions at the bottom of this guide from MS:

Keep in mind your users will have to have Win7 Professional, Enterprise, or Ultimate editions, and the hardware will have to meet certain requirements in order to run XP mode.

Also, I would think that client software would be better for the **server** as it would remove the load from the server.  Whether it is better for the **network** or not is questionable since you are still sending all the data back and forth.   But as I think your goal is to reduce load on the server it is definitely worth doing a trial with a limited user group and then doing some performance analysis on the server and on the network performance.  Be sure to engage some of your power users.

Hope this helps.

Hope this helps.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.