Backing up Your Database ................................................................................................
Everybody knows that data should be backed up frequently, and I like to make it as convenient as
possible to back up a database. My standard database main menu features a Backup button, which
calls the BackupDBprocedure listed next. I created the Backup code and menu button in an ear-
lier version of Access, when there was no way of backing up a database without closing it down.Since that time, Microsoft has added a backup command that doesn’t require closing down the
database, though it’s still not as convenient as my one-click backup. The Access 2007 backup com-
mand is available through the Manage button on the File menu (shown in Figure 9.7). Selecting
the “Back Up Database” option opens the Save As dialog shown in Figure 9.8.Working with Files and Folders 9
An Access 2003 Help topic for the Tab control.