Share via

Issue Opening Access Database

Anonymous
2024-10-29T15:25:58+00:00

I have an Access Database that all of a sudden, I started getting an error, “Microsoft Access cannot open due to security restrictions”, when opening the database. But I’m the only one who gets this error, for everyone else it opens fine, and I created the database! I can’t change Trust Center settings, or edit the Registry, because they’re locked by Admin. Something with my Profile had to have changed, any ideas?

Microsoft 365 and Office | Access | For business | Windows

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

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2024-10-30T13:45:15+00:00

    This is a Database I created about 10 years ago, it’s on a shared drive so multiple people can use it,

    This is the WRONG configuration and may be, at least partially, a source of your problem.

    EVERY multi-user application NEEDS to be split between a back end (the tables) and a front end (everything else). The back end should be on the shared network drive and the front end install on each user's PC.

    You might consider reconfiguring as described and seeing if that helps your problem.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-10-29T19:16:27+00:00

    Yes, all Office Apps (Word, Excel, etc.)

    These are two of the messages I get.

    But, like I said, I'm the only one it's happening to, everybody else can open the files just fine.

    It’s very aggravating because I created the Database and now I can’t open it to update the VBA Code.

    Was this answer helpful?

    0 comments
  3. George Hepworth 22,855 Reputation points Volunteer Moderator
    2024-10-29T18:31:29+00:00

    When you say "all files with micro's", what other files would that include, Word, Excel, etc.?

    Your IT has prevented you from changing Trust Center settings or editing the registry? Yet, they refuse to offer help?

    Unfortunately, this is not an Access problem, nor is it likely to even be an Office problem.

    As a reality check, please post a screen shot of the actual error message being displayed.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-10-29T16:58:41+00:00

    I tried that, they were no help! Is there some setting I could check and compare to another person's profile settings?

    It's not just MS Access, it's ALL files with Macros, but I'm the only one. Very Odd.

    Was this answer helpful?

    0 comments
  5. George Hepworth 22,855 Reputation points Volunteer Moderator
    2024-10-29T16:07:55+00:00

    Check with your IT support. Perhaps they did change something in your profile.

    Was this answer helpful?

    0 comments