This appears to be a bug. Both table and summary export to .accdb fails if add to file is selected. If overwrite file is selected, then it works.
You can open the project file in DPS, and export table to .accdb, which works file, however, currently summary export to .accdb is not supported. Summary can only be exported to a .csv file.
I reported this issue to Datawatch support team.
Is it safe to assume that you have full maintenance support available?
If so I would strongly suggest that you create a support case if you have not already done so. That may, in some circumstances and situations, provide for the earliest possible solution to a mission critical problem. It has to be worth seeking that opportunity.
A temporary workaround is to downgrade to Monarch v15.0. I believe you're using Monarch v15.1 right?
I will give you access to our support portal where you can download the installers. Please expect an email with a password creation link. I also created a ticket for you to make sure you will be informed once v15.2 is released.
Have test v15, this does not work either
Running export job Export1
Export job Export1:
Failed - Export1
The Excel file is incompatible with this version of Monarch.
This is urgent, we cannot undertake critical business processes
Senior Financial Data Analyst
Pay360 by Capita
30 Berners Street, Fitzrovia, London. W1T 3LR
Part of Capita plc www.capita.co.uk<http://www.capita.co.uk>