Share via

Cannot open database in shared mode

Doug Robbins - MVP - Office Apps and Services 323.1K Reputation points MVP Volunteer Moderator
2015-03-28T23:16:18+00:00

Even though Access is set to open databases in "Shared Mode"

when I try and use External Data>Export>Word Merge, it receive the following message:

I have of course done that, but it does not make any difference.  I have also tried switching to Exclusive mode and then back to Shared mode, but once again without it making any difference.

I have write access to the folder where the database is located and an .laccdb file is being created in that folder.

How can I get a database to open in shared mode (the problem does NOT just affect one database, but any of them that I open).

Microsoft 365 and Office | Access | For home | 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

Answer accepted by question author

Doug Robbins - MVP - Office Apps and Services 323.1K Reputation points MVP Volunteer Moderator
2015-03-29T03:56:05+00:00

Thanks, Tom.

Negative on all of those things, but I have now repaired the Office installation and that has overcome the problem.  I should have known to have tried that as I have advised others to do it often enough.

Regards,

Doug

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2015-03-29T02:01:33+00:00

    I'm grasping at straws, but try this:

    Copy the database to your local machine.

    Login to Windows with an account that has local administrator rights.

    Add that local folder to the Trusted locations.

    Make sure the VBA in the database compiles OK and there are no broken references.

    Was this answer helpful?

    0 comments