Help - menu shortcut sources have changed!

[thenoisydrum]

So, I have several menus in one of my databases, all nicely arranged with groups that contain shortcuts that run macros, run queries or open tables.

When I began to run through one of my daily processes today I double clicked the first item and I realised that it was attempting to run a different macro to the one that I originally assigned it to.
I then realised that almost all of the shortcut menu items now 'link' to a different source item to what they should. They are all out of sync.

Has anybody come across this happening before?

I am using Access 2016. I have other databases with menus and it has not happened in these ones.

Thanks in advance

 

[arnelgp]

are the menus on the table? did u make a compact and repair. if you are using autonumber as reference, dont.

 

[thenoisydrum]

I don't understand what you mean by asking if the menus are on the table?

I have compacted and repaired and this has not fixed the problem but I don't understand why you are asking about autonumbers as the reference?

 

[arnelgp]

if the menus are not on the table then how did you put it, hard coded in macro?

 

[thenoisydrum]

The menu is created in the Navigation Options. You call the menu what ever you like and then add objects such as queries and macros into the menu. Access actually creates a shortcut to the object and you can name the shortcut what ever you wish.

So query A0201-Gross-Turnover-YTD could be renamed "01. YTD Sales"

My issue is that all of the shortcuts in my menus now look to different objects to those that I originally added and I cannot work out why?

 

[arnelgp]

i did investigate coz i am also using a2016.
the menu you made are actually saved in the system tabled, MSysNavPaneGroups and MSysNavPaneGroupToObjects.

its an issue of corruption.

its better to start again.
although yiu can edit the table MSysNavPaneGroupToObjects, its too risky.

when you are through recreating your menu, create a copy (copy/paste) of these tables for backup.

 

[The_Doc_Man]

Good advice, Arnel - Especially for the "make a backup." Though I would do that first. ANY time you are doing maintenance, make a backup. Then make a copy. Then update the copy. If it works, THEN replace the original with the copy and make ANOTHER backup. Dump any extra copies of the backups only after the new stuff has been running for at least a few days, long enough to know it isn't going to float belly up in the fish tank.

 

[thenoisydrum]

Thanks Arnel, I'm beginning to understand what you mean now.
I back up all of my databases weekly so I do have a back up copy.

Is it possible for me to somehow copy the system table that contains the menu from the back up copy? Where cn I view these tables?

Thanks in advance

 

[arnelgp]

the tables are hidden so you have to unhide thrm on the nav pane.
ordinary copy and paste will do.

 

[isladogs]

Whilst you can certainly copy and paste the system tables to a new database, you can't overwrite the existing ones nor delete them and replace with the copied table(s)

As arnel has already said, the MSysNavePane tables can be edited but if you do so, take great care.

Personally, I would just delete all existing custom nav pane groups and create them again from scratch

 

[thenoisydrum]

Whilst you can certainly copy and paste the system tables to a new database, you can't overwrite the existing ones nor delete them and replace with the copied table(s)

As arnel has already said, the MSysNavePane tables can be edited but if you do so, take great care.

Personally, I would just delete all existing custom nav pane groups and create them again from scratch

Yes, I think you are probably right on this.
I think I am going to open my backup database on my second monitor as a reference and simply re-add all of the items to each menu again.

Out of interest do any of you know why this may have happened in the first place?

Thanks to all of you for your help