Re: Executing CLI SQL code of BE DB
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.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.