How do I synchronize three separate databases

ACT version 6.0.3.979  Sync has been set up, with another user, using a shared folder for each database.

Three different users each with their own databases share one assistant.  Each user wants to keep their database sperated from the other, even on the assistants machine.  That portion seems to work o.k. as long as the assistant opens the right database when she needs to make a change.  The problem appears when configuring synchronization for the three separate databases and trying to keep everything completely separated on the assistants machine.

The first problem happens because the "All received syncs go" parameter, on the assistants machine, is the last database configured and does not follow the database that has been opened.

The second problem occurs when trying to sync the second users database with the "All received syncs go" parameter set to use a common folder.  I receive an error message from ACT stating that a database packet was found that could not be applied, no reason just couldn't do it.

Is there a way to configure sync this way?  If how, please be specific on how to do it.
c7c4c7Asked:
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.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
The easiest way would be to use AutoAdmin II on the assitant's machine. From memory, you can set it up to handle multiple databases with different sync paths.

You can download a trial to test this from http://www.glcomputing.com.au/main/16/2
0
SStrozCommented:
c7c4c7,

I wouldn't try this method - it's doomed to fail.

I would use ACT!'s group feature to set-up sync.  In other words, merge the databases into one Master database on the admin's workstation.  Then create 3 seperate groups inside the Master database - one for each remote user.  Then synchronize with each remote user using only their group (instead of "all" contacts).

The remotes will only have the appropriate contacts, the admin will have all of the contacts, and it will be easy to maintain from a synhcronization perspective.

Let us know if you have any other questions

Steve
0
c7c4c7Author Commented:
SStroz
Can't do the group feature, the databases have to be maintained separately

GLComputing, how long has your product been available and how widely used is it?

Thanks
0
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
It's been available since ACT! 4/5 - so, before 2000.
It was probably the most widely used ACT! 5/6 add-on as it did automated backups and syncs that were not available to ACT! users.
0
c7c4c7Author Commented:
GLComputing
Thanks for the tip but it has the same problem as ACT.  Unfortunately you can only have a single folder for the all received syncs folder.  

Still need some help here if anyone has any suggestions

Thanks
0
SStrozCommented:
c7c4c7,

Don't shoot the messenger - but there really is no elegant way to handle your scenario outside of upgrading to the latest version of ACT! which can accomodate this.

The only way to do this in the current version is teach the main sync administrator how to change the preference for the inbound folder - but as I mentioned in my original post it's doomed to fail because inevitably they will forget.  (I've been there - done that).

Wish there was different news...

Steve
0

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
c7c4c7Author Commented:
I pretty much had come to that conclusion, but I was hoping I had missed something
Thanks for the help
0
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
ACT

From novice to tech pro — start learning today.