Access Message Bar Not Functioning Properly

Question

I am currently working in Access 2016 and ran into a problem where the message bar is no longer showing up, so I can't enable my database content. The issue stems from my a simple four-step macro that I wrote (details below; I put placeholder names instead of the real ones):

1. SetWarnings: No
2. CloseWindow: Form; FormName; Prompt
3. OpenQuery: QueryName; datasheet, edit
4. OpenForm: FormName2; Form; ; ; Normal

Because my message bar isn't showing up, Access is not running the macro due to the SetWarnings command. Now, I know I can easily remove that command and the system will work fine, but I use that command in several of my other databases, and the issue seems to have spread to all of them. As of Friday evening, the databases were working fine, but when I showed up to work this morning, the message bar stopped showing up and started causing problems for me.

I've done the following to try and resolve it:

1. I've tried Compact and Repair several times
2. I've added a new Trusted Location and selected the option to trust sub-folders
3. I've checked the message bar settings to make sure that the correct box is checked "Show the message bar in all applications..."
4. I've checked my Macro Settings to make sure that the correct box is checked "Disable all macros WITH notification"
5. I tried clicking "Allow Trusted Locations on my network (not recommended)" but unclicked it after I realized that it did not fix the issue.

We use Dropbox as a way to share databases, and I have never run into this issue before. I'm not sure what would have changed between close-of-business on Friday and this morning, but some kind of setting has changed that I am not familiar with, and it is preventing me from having working databases. Would be great if someone could offer any advice or solution as to how I can fix this.

Answer 1

If you've created a Trusted Location for the FE, then you wouldn't be presented with the Notification Bar anyways.

"We use Dropbox as a way to share databases, and I have never run into this issue before" Using an Access db over a WAN is risky business.  Make sure you have proper backup strategies in place!