Data Management

Database name has gone missing in Access 2007

Access 2007 no longer displays the database name by default, but there's a setting that works just as well.

I received a confusing email from a user not too long ago—they're new to Office 2007 and Access wasn't displaying the name of their database anymore. "It's always been there before!" It took me a minute to figure out what they were talking about. The user was right. Earlier versions of Access automatically display the database name in the Database window's title bar. There is no Database window in Access 2007, so naturally, that feature is gone as well. It was a good opportunity though for me to show the user how to display the database name in the application title bar. Doing so lends a bit of familiarity to the users—they like it. To display the database name in the Access 2003 title bar, do the following:

  1. Choose Startup from the Tools menu.
  2. Enter the database name you want users to see in the title bar in the Application Title box.
  3. Click OK and you'll find the name you entered at the left edge of the application title bar.

In Access 2007, the process is considerably different:

  1. Click the Office button and then click Access Options.
  2. Click Current Database in the left panel.
  3. In the Applications Options section, enter a name in the Application Title box.
  4. Click OK and Access displays the name you entered in the middle of the application title bar.

If you have an icon file for your company logo, you can also display it in the title bar, using the Application Icon setting. My caller was correct—Access 2007 no longer displays the database name automatically, but using the title bar setting takes only a minute and will yield the same result, almost.

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks