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