09-20-2011 03:04 PM
I have ACT! 2011 Pro and two offices. We are a small organization and do not wish to subscribe to a cloud or host service. I have used ACT! along time and just now have to sync with a new employee. Before purchasing the newer version I was told by sales I could set up a copy of my database on a portable drive for my new employee to work from at his home office. He could then bring the drive in to my home office and we could sync the databases. I have not been able to do this and have read and researched.
If anyone knows how to accomplish this you would be a savior.
09-20-2011 03:16 PM
You can't sync that way ... you may find the best way is to use Hamachi VPN: as per this ACT! Knowledge Base article -
09-21-2011 07:07 AM
Welcome to the Sage ACT! Online Community!
2 things to consider:
1. While there are ways to use an external drive and take a database from computer to computer, it is not a recommended process as SQL requires the database to be on a local drive and this setup could cause corruption within the data.
2. You are running Sage ACT! Pro: If your main (publisher) database is on the same computer on which you intend to open the external drive database - you will not be able to sync. The Pro version requires both the main and remote databases be open at the same time and that is not possible on a single computer.
Mike has mentioned the Hamachi VPN setup (a reliable option), but there are free VPN services available - which can be found using a web search engine (ex: Google).
09-21-2011 07:11 AM
On a side note: You can certainly use an external drive to take a backup of a database to a different computer > restore it > then import the changes into your database. But that is not true synchronization.
09-21-2011 07:34 AM
Note: Always create a backup of your database before importing into it. Use File > Backup > Database option.
You can create a backup of the database by using the File > Backup > Database option. This will create a zip file that can then be place on the external drive. Once connected to the receiving computer, copy the zip file to machine and then use the File > Restore > Database > Restore As option. This will create a new database on your machine.
You can then use the File > Import (or Export) function to perform the import of the data.
Once this has been done, create a backup of the newly updated database and take it back to the first computer to be restored as a new database (no longer using the previous database).
Here are article with more in-depth information:
- How to Backup/Restore your database: KB Article 19211
- Best Practicees for Import/Export: KB Article 17539
09-21-2011 07:35 AM
09-21-2011 07:53 AM