How to Access a Remote or Cloud Database

You might want to store your AvanTax eForms databases on a remote server or cloud storage service instead of a local network server or hard drive. In some cases this will result in performance issues.

Here's how you can make AvanTax eForms work better with remote storage services:

Remote Storage is Slow by Default

Remote storage services (whether cloud or VPN) are not as responsive as local storage and "Not responding" may appear in eForms' title bar when accessing a remote database. This message indicates that eForms is busy updating the database (not that it has stopped working) and normally disappears after a moment or two. If the message appears too frequently or for too long, we recommend using a local storage system.

However, if you must use remote storage, one of the options below may help to improve AvanTax eForms' performance:

1 ) If Your Remote Storage Service Saves a Local Copy of Your Data

Since eForms performs best with databases on local storage, open the local database and rely on the remote storage system's synchronization schedule to upload the database to the remote storage service.

This solution works well in single user situations but not in multiple user situations.

2 ) If Your Remote Storage is Online Only

eForms may be able to access data stored remotely by mapping a drive letter to the remote storage location and designating it as the database location in eForms, but you may find that eForms performs very slowly in such cases. If so, your only option is to install the eForms application on the same remote storage server as the database to enable the application to have local access to the database.

This solution works well in both single and multiple user situations.

3 ) Steps that May Improve Online Performance and Data Integrity

Remote database solutions are typically unsuitable for use with locally installed applications but if you have no option other than to store eForms' databases on a remote storage service then the following may improve performance somewhat and reduce the risk of data corruption:

  • Instead of having eForms' data in a single database, divide it among mulitple smaller databases to reduce the volume of data being exchanged over the remote connection
  • eForms updates summary data as slip data is entered and performance can be improved by also opening the summary data entry screen while entering or editing slip data
  • Limit the use of eForms' databases to one user at a time, this will reduce the potential for errors and corruption caused by delayed database writes from multiple users

And you're finished!

Return to eForms QuickHelps

"I just have to tell you how great it is to work with a company that has such a good support team, it is a joy to talk to someone who knows the product and wants to help us make it work."

Here at AvanTax eForms, we are dedicated to a standard of exemplary customer service. Being in the buisness for over 30 years has taught us that customers want informative, effective and friendly service that caters to their immediate needs.

Support is avaliable all year round. We're committed to answering your questions promptly and courteously, so if you get our voice-mail, leave a detailed message, including contact information and we'll call you back as soon as we can.

If that sounds like something you might need, give us a call:

English Technical Support

Telephone: 416 495 1624
Toll-free: 800 268 3211
Fax: 416 495 0044
Live chat: 

Click only when instructed

Soutien technique en français

Téléphone : 514-499-9669

Télécopieur : 514-499-9669
Courriel :
Clavardage en direct : 

Cliquez uniquement sur instructions