Forum Discussion
John_Wood430
Jul 15, 2022Copper Contributor
Access does not respond when creating a query
 When I create a new query Access asks what type.  I select a simple query.  When I press enter access does nothing.  A Spinning circle appears.  Eventually it tells me Access is not responding. 
Chuck1017
Aug 23, 2022Copper Contributor
A client has the same issue that just showed last week. Access goes not responding when using the Query Wizard and picking simple query. I've tried on 4 machine with 3 different databases and all have the same issue. They all have Office 365 Access 15427.20210 or 15437.20194. I tried all three databases on an old machine the has Office 2013 Pro installed and they work fine. Seems like maybe an Office 365 update broke this feature?
George_Hepworth
Aug 23, 2022Silver Contributor
There is a recently reported bug using wizards, although I don't recall specifically that it impacted the Query Wizard. It probably does as well.
It happens with tables that have an MVF or attachment field in them.
- Chuck1017Aug 23, 2022Copper ContributorThanks for the response, so you're saying we have hope that someone is looking into this issue.
 Thank you- George_HepworthAug 23, 2022Silver ContributorYes, as long as it turns out the problem is general to all wizards. Also, can you confirm that your accdb does have an MVF or attachment field in the table which raised the error?- John_Wood430Aug 24, 2022Copper ContributorYes that is true.