Extras Options ........................................................................................................
This selection opens a setup dialog (shown in Figure 14.21) with an option group for selecting the
folder for storing database backups, and two subforms listing the table and query prefixes for
tables and queries you would like to omit when using the List Query Fields or List Table Fields
add-ins. These tables are pre-filled with system prefixes, dashes and underscores, and “Copy Of”
(the latter is the prefix used in Access 2007 object copies).If you select the Custom Path option, a command button is enabled that opens a Folder Picker dia-
log where you can select a custom backup folder. The backup choice is stored separately for each
database, using database properties; the prefixes, however, are stored in the code database, so they
are the same for all databases.You don’t need to open the Extras setup dialog to use the other menu add-ins; if you haven’t made
any selections, the code uses the default backup choice of option 2 (Backups folder under database
folder), and the standard prefixes.Creating Access Add-ins 14
Signing Add-in Code with a Digital Signature — Not!
Y
ou may be used to signing code in Access 2003 (or earlier) databases with a digital signature (see
the "Creating a Digital Signature for Signing Your Access VBA Code" Sidebar in Chapter 12 for
details on how to create your personal digital signature). It might seem like a good idea to sign an
Access 2007 add-in's code with a digital signature—but if you try it, you will run into roadblocks.
After creating a personal digital signature, if you try to select the signature from Tools, Digital
Signature in the add-in's module window, you will get a lengthy and puzzling message (see the fig-
ure below). Note that the .accda format is not mentioned.
You can follow the instructions for an .accdb database, and select File, Publish, Package and Sign
from the library database, select the digital signature, and create a signed package (it will have the
.accdc extension). But if you attempt to install the .accdc file as an add-in, you will get an
"Unrecognized database format" error message, and you can't install the signed package file. Thus
(at the present time, at least) there is no way to digitally sign an Access 2007 add-in library database.