Executing CLI SQL code of BE DB
I would like to find a way to execute SQL code on a remote BE server. Most of the code is going to be simple SQL schema maintenance like adding tables, or columns. There might be some creation of views or triggers.
The reason for this is simple. A client gets a new version of the software (access ACCDB) but the new version requires some extra data to be stored. I want the Access program to automatically update the DB schema on its own.