Hi Paul,
I have implemented using the different VBOs available at our disposal - the error message and at which action is described below.
The bot is trying to execute a macro in the access DB.
Using VBO Data OLEDB
At Execute step : Internal : Could not execute code stage because exception thrown by code stage: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
Using ODBC Database Connection
At Open : ERROR [IM010] [Microsoft][ODBC Driver Manager] Data source name too long
Using Data OLEDB Extended
At Execute :- Internal : Could not execute code stage because exception thrown by code stage: The Microsoft Access database engine cannot find the input table or query 'Macro_CorpWrite_UpdateBook'. Make sure it exists and that its name is spelled correctly.
The Macro is actually available and is named as is in the DB.