Executing CLI SQL code of BE DB (1 Viewer)

GregoryWest

Registered User.
Local time
Today, 06:14
Joined
Apr 13, 2014
Messages
161
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.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 06:14
Joined
Feb 28, 2001
Messages
26,996
As to the mechanics of it, just look up DDL (Data Definition Language) for Access. Some back-end DBs require that you have a passworded session in order to modify a schema.

However, strictly speaking, you would have to use a pass-through DDL statement if you wanted it to run on the BE. But you COULD run it through Access if your ODBC interface to that back-end allows DDL. Look that up in the tech manuals on the target system.
 

Users who are viewing this thread

Top Bottom