Setting sync frequency

Updated 2009-09-24 | Filed under Geosync | PDF

Question

How often does Geosync sync my Access database with the server?

Answer

By default, synchronization only happens when you click the EQL Sync toolbar button. That gives you the most control over when you're ready to sync. Unfortunately, it can be easy to forget to do this.

Please use our Feedback site if you'd like to suggest and vote for other ideas.

Scheduling a sync with Windows Task Scheduler

You can use the eql.exe command line tool to sync your database with the server on a schedule, using the Windows Task Scheduler. Create a new scheduled task, then change the command line to look like: 

"C:\Program Files\EQL Access Plugin\eql.exe" sync --file="C:\path\to\your_database.mdb" --server=http://eqldata.com

You may have to change the path to eql.exe if you installed it in a non-default location. You also still need to have Access installed on the machine when you run eql.exe.

Causing a sync from VBA

If you're a programmer, you can use a VBA script or macro to sync your database with the server whenever you want. To initiate a full two-way sync, just run EqlSync: 

EqlSync()

Advanced: Partial syncs from VBA

Alternatively, you can run each half of the EqlSync operation separately. EqlSync is equivalent to: 

EqlPush()
EqlPull()

EqlPush sends all updated data to the server, but doesn't ever change your local database.
EqlPull does the opposite; it retrieves the most recent version from the server and replaces your database contents with it.

It is safe to run EqlPush as many times as you want without running EqlPull; this is a good way to back up your database, even if you aren't interested in seeing other people's changes yet. Other people will see your changes, but not the other way around.

You can also run EqlPull whenever you want, and you will receive all the changes other people have sent to the server. However, you will lose your own local changes unless you have first run EqlPush.

Related Articles

Unrelated Articles