I have an app where the user is requested to provide an Access database file, at which point an Input Data tool tries to import a few specific tables.
If one of the tables doesn't exist, the app ceases and Alteryx provides an error message stating as much. Is there a way to customize this error message? And(or) have the app ignore the error and continue if at least one of the tables successfully imported?
Maybe if you have a chained app, the first one reads all tables names from the file and checks which tables are present. Then, considering that you have one Input data tool for each table name, the second app enables or not containers that has those input data tools based on the list of tables from the first app.
Is there a way to obtain a list of table names without using MsysObjects?
I am sorry, I am not that familiar with Access database files. Maybe someone else here can answer this.