Problem using Microsoft Access with Linked ODBC Tables using a SQL Connection

Not sure there is a solution here.

I have an Access DB that serves as a front-end to a Sage 50 Accounting reporting tool. Works great!

However, we need to grab data that is in a query with native MS Access tables joined to a couple Linked Sage 50 databases.

If I attempt to run a SQL against the above referenced query (Sage 50 Linked data & native SQL), it generates the error below.

Note: SAGEODBC is the name of the ODBC connection that MS Access uses to connect to Sage.

Correlation Id: d08e5adc-d464-41c8-891d-16d044572d07

ODBC--connection to 'SAGEODBC' failed.: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Error in SQL statement ODBC--connection to 'SAGEODBC' failed. ---> System.Data.OleDb.OleDbException: ODBC--connection to 'SAGEODBC' failed.
 at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
 at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
 at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
 at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
 at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
 at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
 at Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.DatabaseActions.ExecuteSQLStatement(Variant connectionString, Variant sqlConnectionVariable, Variant sqlCommand, Variant& result, Int32 timeout, Int32 getConnection)
 --- End of inner exception stack trace ---
 at Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.ExecuteSqlStatement.Execute(ActionContext context)
 at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

Any ideas are appreciated.

Thanks.

Quick Links

Leaderboard > Power Automate - Power Automate Desktop