Can a system variable table be tied to an access database to update automatically?

Question

What is the syntax to use QIE.setVariable() to update a variable table?

Answer 1

A QIE System Variable table is stored inside the QIE database as a CSV string.  It can be updated within a script using the qie.setVariable() method.  So, yes, you could create a channel that updates the system variable table.

However, you should be able to connect directly to the MS Access Database from within QIE using a JDBC driver.  I have not personally connected to a MS Access Database, but it looks like there is documentation and examples online.

https://msdn.microsoft.com/en-us/library/9bbt582h(v=vs.80).aspx

http://stackoverflow.com/questions/21955256/manipulating-an-access-database-from-java-without-odbc

You would create a new Database Connection and specify the Driver Class, Connection URL, etc.  Let us know if you need more help.