Share via

Microsoft Access

Heather McCalla 0 Reputation points
2025-12-07T01:26:05.5166667+00:00

I downloaded a file through microsoft access for a school project. I enabled the macros because the file was "untrusted". I consistently saved the project but eventually it randomly reloaded it and said it blocked macros even though i have macros on. i've literally tried anything, is there any way to get my work back, it is all gone.

Microsoft 365 and Office | Access | For education | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gabriel-N 9,950 Reputation points Microsoft External Staff Moderator
    2025-12-07T09:41:01.1233333+00:00

    Dear Heather McCalla

    Thank you for reaching out to the Q&A forum.

    Could you please clarify what you mean by “I’ve tried everything”? It would be helpful to know the specific steps you’ve already taken so we can avoid repeating them. For example, have you tried the following steps?

    • Unblock the file: Right-click the file > Properties > click Unblock if available.
    • User's image
    • Macro settings: In Trust Center, set macros to Enable macros or Disable all macros with notification.
    • Add a Trusted Location: Add the folder where your file is stored as a trusted location in Trust Center Settings.

    When you say “it’s all gone,” do you see a blank gray screen, or do you still see tables on the left but they are empty? Please also try these:

    • Open Access in Safe Mode by pressing the Windows logo key + R, typing msaccess /safe, and pressing Enter. Then open your file in this mode.
    • Open the file, then go to File > Info > Compact & Repair Database to run the repair process and check if it resolves the issue.

    Could you provide a screenshot of what you see? Please send it via private message so I can better understand the issue. You might also find this thread helpful: I want to unblock my Microsoft Access File

    User's image

    Looking forward to your response so I can assist you further. Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.