06-23-2012 01:59 PM
I'm using ACT Pro 2012.
I am trying to sync a database with a partner working remotely. I've been setting this up with two computers on my LAN, but I can't see how it would work for someone who isn't on the LAN.
I created the remote database and located it in a Google Drive folder. I set the main database to accept incoming syncs.
On the other computer, I opened the RDB file and created the secondary database. Then synced to the main database as instructed. I made a couple of changes and synced again to confirm that synching is working.
But the sync seems to work through a port on the main computer, not through a file.
I don't see how my remote partner can sync using a file, or over the Internet. The documentation mentions internet sync, but I don't see the option when I'm setting up syncing. A file would be the easiest. That's the way it used to work I think.
I'm sure I must be missing something obvious.
06-23-2012 02:32 PM
There isn't any sync file created with ACT! 2005 and later, the sync is a direct ink between the host and remote database. The simplest is over a LAn but you can sync suing a virtual private network. Check this KB. http://tinyurl.com/5cbkr2
06-24-2012 04:14 PM
Not having the file / email syncing is a bit of a nuisance. I don't remember using it much, and it was years ago, but I don't think it was all that complicated.
Setting up a VPN is more than I want to get into at this time, so here's what I've settled on - not quite working yet. I'd appreciate comments as it may not be foolproof, and I think it might have security issues. Some of these steps might not have been necessary.
After this, I'm able to access from the machine the database resides on, and the machine I use most. But when I tried from one of the other computers to simulate how my partner would access, I only got partway.
I can see the logon screen for the shared database, and then logon as my partner. But then ACT presents an error message about the supplemental files not being accessible. I've found some references, but I don't see anything wrong.
06-24-2012 06:55 PM
In the first place the file / Email sync was a Kludge, hard to setup properly and prone to failure. (I knoe because I wrote the KB documents on setting up sync on ACT! 6 when I was in tech support. What you're trying won't work for anyone but ypu because the database is attached to the SQL server on your system and your partner can't access the SQL server on your system.
Read the KB I referred you to, here is the link again. http://tinyurl.com/5cbkr2
It's a relatively simple process, much simple than the old Email sync in ACT! 6.