Updating an MS Access database

There are two ways to update an MS Access database on our system. You can update your database offline and reactivate the revised version, or update your database in real-time using a scripting language.


If an MS Access database is modified offline and the revisions should be reflected on a website, follow these steps:


  1. Update the database offline.

  2. Copy the new version of the database to the correct location.

  3. If you are using a connection string rather then an assigned DSN, please email technical support to activate the modified database.


Alternatively, there are a variety of ways to update a database with a scripting language.  The method you use will depend on design, skill level and personal choice.