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:
Update the database
offline.
Copy the new version
of the database to the correct location.
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.