Access 2016 Dragging Queries into Macros crashes Access

When creating macros in Access 2016 if you drag a query into the macro into white space it works fine and adds the query however if you happen to drag it over another query access with crash, no errors or anything just crash out.

I recreated the issue in our environment with a blank database to remove any other variables that our production databases may inject to the issue and I get the same behavior.

I've also tested on a fresh windows install with Office 2016 installed from the office 365 portal.

Users on the access for developers forums were able to recreate the issue as well.

Thanks,
Eric

16 votes

Eric Alcott shared this idea · April 06, 2016 · Flag idea as inappropriate… · Admin →

Reviewed for future consideration ·

AdminAccess Team (Product Manager, Microsoft) responded · April 11, 2016

Thanks for posting this behavior here!
We are looking into it.

Thanks,
Michal [Microsoft]

6 comments

An error occurred while saving the comment

Robert commented · June 03, 2020 07:21 · Flag as inappropriate

Something changed mid-2020 with Office 365 causing significant performance issues in Access. Normal nightly updates that were taking 8 hours suddenly took 2.5x longer. I had IT uninstall 365 and replace with stand-alone version of Office 2016. That fixed the performance issue, but now I have this crazy drag-drop-crash issue in Access. Queries can still be added to macros through the drop-down, but it removes a useful productivity feature. I'm confounded by how a product (O365, 2016, doesn't matter) can be this buggy given its age and supported by a company as well-endowed as Microsoft.

Submitting...
edwards142 commented · August 02, 2018 22:51 · Flag as inappropriate

Well I have encountered through this MS Access crashing issue each time I tries to open my report in Access. So, the solution which I have tried to resolve it out, I can share with you all. Try them out and easily get rid of this MS Access crashing issue whether it is occurred in any of the MS Access version 2007/2010/2013/2016.

I found this helpful post, after a searching a lot for the fixes when I too stuck with such an issue. ….so good luck and share your experience after trying.

source:
http://www.accessrepairnrecovery.com/blog/fix-ms-access-keep-crashing-issue

Submitting...
Anonymous commented · November 15, 2016 03:51 · Flag as inappropriate

Any update on this?

Submitting...
Tyler Pickering commented · August 26, 2016 08:07 · Flag as inappropriate

Has there been an update to this issue?

Submitting...
matt commented · July 14, 2016 07:48 · Flag as inappropriate

I have this exact same issue.

Incredibly frustrating.

Submitting...
Lawrence Welsby commented · May 26, 2016 08:04 · Flag as inappropriate

Having the exact same issue.

Submitting...