Share via

Access 2016 Wizard function crashing database

Anonymous
2022-07-25T18:15:43+00:00

After successfully building tables, queries and forms in my Access Database I suddenly can't use the "Query, Form or Report" Wizard function without the database crashing with a (Not responding) status and hanging up on that status until I close the database. I've tried the "compact and repair" feature to no avail. Any other ideas out there?

Microsoft 365 and Office | Access | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-29T07:43:08+00:00

    I am having the same problem with Access 365. This is happening in several of my databases where I have several fields that are LookUp Fields with Multiple Values allowed. If I remove the LookUp values, I can create reports but that defeats the whole purpose of using Access for these databases.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-07-29T13:11:08+00:00

    Good Day,

    I am experiencing the same thing. Also, my general options doesn't have the Disable hardware graphics acceleration.

    Thank you

    Stacie

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-09-07T13:14:07+00:00

    Hi,

    Nowadays it's usually this update bug: Access stops responding when running Report Wizard

    Servus

    Karl

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-09-07T11:39:38+00:00

    I have the same problem and I'm so surprised there is no reply to you, this is such an important feature!

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-07-26T03:41:33+00:00

    Dear Tami,

    Good day! Thank you for posting in Microsoft 365 and Office Community.

    Based on the description you are encountering a situation where Access 2016 stops responding when you use Wizard functions.

    As Access database crashes could be caused by multiple reasons, we kindly ask you to try the following troubleshooting steps and share some additional information to narrow down the source of this behavior:

    • Please check if you encounter the crashes on another PC. If the issue appears only on a certain machine, then it can be the issue of low memory space. So, just check out the memory space of your system before working on it. You may also temporarily disable anti-virus.
    • May I know if your database contain OLE Object Fields? If the database contains images or other OLE objects fields then this can often cause issues.
    • Disable Hardware Graphics Acceleration in the File > Options Generaltab, choose the checkbox forDisable hardware graphics acceleration.
    • Check your Trusted Locations. Click the Fileicon, and then click Access Options. Click Trust Center in the left pane, and then click Trust Center Settings. Click Trusted Locations in the left pane, click to clear the Disable all Trusted Locations, only files signed by Trusted Publishers will be trusted check box, and then click OK two times.

    Thanks for your cooperation. Look forward your reply.

    Sincerely,

    Igor | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications"

    Was this answer helpful?

    0 comments