Question Action Catalog doesn't work

[chuckcoleman]

I'm using Access 2010. In one database the Action Catalog works fine when viewing the design of a macro. In another database, it won't open when I click on the Action Catalog button. I've compared the options for the Current Database in both database Options and they're the same. How do I get the Action Catalog to work in the one? What's preventing it from working?

 

[AccessJunkie]

Hi Chuck,

This is very odd indeed.

Is there any chance you could attach a copy of this database that repros the issue? You could probably just make a copy of the ACCDB and delete all objects except maybe one macro to protect any proprietary data/objects.

I'd like to see if I can see the same issue on my machines with your database.

Also, could you tell me about your system a little bit?
What operating system?
Are you using 32 bit Access 2010 or 64 bit Access 2010?
Screen resolution?

Thanks,

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[chuckcoleman]

Access Junkie/Jeff,

Well, I should have done something before I posted my issue. After you replied, I created a new blank database and then imported all objects into it. The problem went away. The database had originally been created in Access 97 and I was in the process of updating/converting it to 2010. I had already changed the file type to accdb. It is running on Windows 7 using 32 bit Access 2010 with a screen resulution of 2048 X 1152. SO, sorry but thank you for a quick response. I have more development work to do so hopefully importing everything solved/fixed the issue(s). Thank you again.

Chuck

 

[AccessJunkie]

Hi Chuck,

Thanks for checking back.

While waiting, I asked around the team and did some testing. I can repro your issue now and I understand the cause and fix.

The issue is most likely you are using a MDB file and you had the following option disabled in the Options dialog:
Allow Built-In Toolbars

The Action Catalog follows that setting so if you had it turned off, the Action Catalog won't be visible. Setting that option back to True, closing and then re-opening the database should make the Action Catalog appear again.

By importing your objects into a new ACCDB container, you won't have this issue, because the Allow Built-In Toolbars setting is not available with ACCDBs.

For my benefit, can you confirm that you were using an MDB and had that setting turned off?

I'll make a new FAQ page on my site in case other people hit this issue.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[chuckcoleman]

Jeff,

Well, close but not cigar. The database that was having the issue is an accdb database. Also, in Options, in Current Database, under the "Ribbon and Toolbar Options", Allow Full Menus and Allow Default Shortcut Menus ARE BOTH CHECKED. Are those the options you were referring to?

Chuck

 

[AccessJunkie]

Hi Chuck,

Thanks for the information. The repro steps I provide will reproduce the issue 100% of the time so that's definitely something other people might fall into. I've created a new FAQ page on my site to help people that come across this issue:

http://accessjunkie.com/faq2010_73.aspx

I'm surprised to hear this was an ACCDB. Did you convert the database from a previous MDB? If so, that again I think is the same issue - the property came along with the conversion.

With an ACCDB, you won't see the Allow Built-In Toolbars option. To test, create a new MDB in Access 2010 and you'll see this additional third option listed in the Ribbon and Toolbar Options section.

Thanks for the update; glad to hear everything is working now for you with the Action Catalog.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------