ExcelBanter - Error trying to run a query in Access from macro in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Error trying to run a query in Access from macro in Excel (https://www.excelbanter.com/excel-programming/344674-error-trying-run-query-access-macro-excel.html)

Pete[_24_]

Error trying to run a query in Access from macro in Excel

On this command:
Acc.DoCmd.OpenQuery "EBITDA tempfile Query"

I get a message:

run-time error '2486':
You can't carry out this action at the present time.

Why? How can I fix?

All times are GMT +1. The time now is 05:13 PM.