If you run this command in a database that has no linked tables, you will instead get the message
shown in Figure 15.21:FIGURE 15.21
A message when attempting to back up the back end for a database that has no linked tables.The procedures for the “List Table Fields”, “List Query Fields”, “Select Options”, “Back up current
database”, and “Back up back end database” buttons are similar to those in the Extras 2007.accda
add-in, except that they use the ByVal control As IRibbonControl argument that is needed to run
them from Ribbon buttons; their code is not listed here.Summary ..........................................................................................................................
Although at first it may appear that the new Ribbon is not customizable, you can in fact customize
it, at least by adding new tabs and groups, with controls to run your code. This chapter covered
writing XML code to load a custom Ribbon, and VBA code for procedures to run from the custom
Ribbon buttons, both in regular Access 2007 databases and in library databases for Access 2007
add-ins. The next chapter describes how to write Shared add-ins working with the Access Ribbon
in Visual Basic 2005.Part III Adding More Functionality to Office