Does Access Runtime disable right click menues?

Question

I have an Access 2007 Database (FE & BE) that I am deploying with Access 2007 Runtime. My test computer is running Windows 7.

My current problem has to do with the pop-up menus that appear when we right click. I rely on these to print reports after previewing. This works fine when I'm working with the Development copy and the full version of Access. However, on the test computer, I'm not seeing any dropdown menu when I right click.

I've looked at the Access Options, and the "Allow Default Shortcut Menus" option is still checked.

Is there something else I might have done to cause this behavior. It is certainly unacceptable!

Thank you for any advice you can offer.

Answer 1

The runtime version disables both the built-in ribbon and the built-in context menus. You will have to provide your own.

Unfortunately, there is no way to create or edit context menus in the Access 2007 interface,

You CAN create context menus (right-click) by building macros in the traditional way in 2007.  I know because I've done so in our mdb files.  I just did a test in an ACCDB file and it is totally possible to do it there as well.

Answer 2

Unless you have specifically disabled them, if you open a Report in Print Preview mode, the Runtime will display the Print Preview ribbon and you can choose to print from there. I do thios all the time. All my users use Runtime.

Answer 3

Hello Hans, Scott, and Bob,

Thank you all for the answers.

I tried finding the "traditional" way of building right-click menus by building macros. (I try to avoid building macros, so I'm not very practiced at it.)

Anyway, my solution was to add one more command button with the printer icon for each report. Now I can open the report to preview and then click on the printer icon to print.

I'm sure there was a more elegant method, but I couldn't wait to learn it.

Answer 4

The runtime version disables both the built-in ribbon and the built-in context menus. You will have to provide your own.

Unfortunately, there is no way to create or edit context menus in the Access 2007 interface, you can only create them using VBA. Or create them on a computer with an older version of Access and import them into your database.

By the way, you can test how a database behaves in runtime on your own computer with the full version of Access:

• Press Windows key+R to activate the Run dialog.
• Enter a command line such as

"C:\Program Files\Microsoft Office\Office12\MSAccess.exe" "C:\Databases\MyDb.accdb" /runtime

If you have 64-bit Windows 7, change Program Files to Program Files (x86)