Monday, August 26, 2013

MS ACCESS Navigation Pane Add Item Greyed Out 2002,2007 and 2010?

This is a bug resolved by guest posted at:
    office-forums.com


The solution apply to my situation, where I upgraded my secured (user level security) database from MS ACCESS 97 to ACCESS XP (2002) and opened with MS ACCESS 2007.

I couldn't tell you that this always happen. Because I believe I was able to open MS ACCESS XP database in MS ACCESS 2007 and see the Navigation Pane worked the way it suppose to and this is why I was at lost when this happen to me.

Through my (Google) search, it seems it affect MS ACCESS 2003, 2010 too.

Here is a copy of the solution posted at office-forums.com:
===========
You'll need to right click the Navigation Pain bar- select Category - select
Table and Related Views - click Ok when a message appear and wait until it
completes.

Now, right click on the Navigation Pane bar again, select Navigation Options.
Now you should see the left listbox "Categories" filled with one category.
Click add under categories to add one sample name it "test" and now on the
right listbox "Groups for "test" appears and the button at the botton "Add
Group" is enabled.

The so called bug only confuse users if there are nothing in the listboxes
and disabling the buttons is really uncalled for. Something MS Access Team
need to fix.

===========

The solution isn't very neat in that the created 'Table and Related Views' Category can never be deleted. But other than that, things seem to work just fine.

From time to time we all benefited from other people's finding and we should credit them whenever we can.

== Added on Aug. 29, 2013 ======
A problem is discovered on Aug. 29, 2013.
If the .mdb file is in MS ACCESS 2000 format and the category is setup in MS ACCESS 2007, login with MS ACCESS 2010 will remove that (could be all) category. However, if the category was created in MS ACCESS 2010, category will stay if login with older version of the ACCESS.

No comments:

Post a Comment