How to sync ACT database with on-site database and off-site staff

I have ACT 2007 5 user software. I need to know if it is possible to install ACT to a main server which will allow my users to access the database between them, and also allow a user to go off site with a laptop and be able to access the same data and then sync the data when they come back to the office?

Any help is most appreciated,

SCOTT78Technical AdvisorAsked:
Who is Participating?
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.

Yes, this is possible. With only five users you don't need to worry too much about running an SQL Server version so basically install the Act! application on a centrally accessible machine. Create the database you want them to share and under the Tools|Database Management select Share Database.

Check that windows is sharing the folder containing the Act database files then you can point office based users at that file directly through the windows share (Just File|Open browse to the share on the central machine and find then open the Act! database file), you'll want to create a username and password for each user.

For the remote user, they will need to synchronise their database which means you need to create a remote database on the main machine (youl;ll see the details in the supplied online manual but basically you use the Tools|Synchonisation Panel - Create Remote Database), the remote user will then need to restore the database  (File|Restore|Database then select Unpack and Restore Remote Database) and provide the file (.Zip) that the create remote built.

This will then make a local copy of the data which will be accessible when out of the office. The user will need to synchronise periodically to keep it up to date.

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
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Assuming it's not the Premium build, this is the way to set up sync to a laptop user -
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.