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.

9 comments
trangcw
trangcw

The same information can be seen by hovering your mouse pointer over it's task bar icon.

rw2000
rw2000

I found that when I made the databases use the Tabbed Documents setting (Access Options -> Current Database -> Document Window Options), the database name shows up in the title.

jabid
jabid

Just out of curiosity, did the author dictate this article into a speech-to-text program? The word "refusing" seems "confusing". Not complaining, just interested.

ainow
ainow

Did not save. Following your instructions changed the title, but, did not display the icon and after closing the application and reopening the title returned to the name of the program.

Glenn from Iowa
Glenn from Iowa

Maybe the title bar displays differently in a different environment - I'm using Access 12.0.6423.1000 on Windows XP SP3 - but even though there may not be a "Database" title bar, the application title bar for Access has the database file name in it. For the database file MyDB.accdb, the Access title bar displays 'MyDB : Database (Access 2007) - Microsoft Access'. When I change the Application Title to 'MyDB', the title bar displays just 'MyDB'. The disappearance of the "database" window is a big change from A2003 to A2007, but in my experience, the file name still displays. Having said that, it can be useful to know how to set the Application Title and/or Icon, as well as the other options, such as an auto-loading form. The advantage of having the filename in the title bar is that it changes automatically when the file gets renamed. Perhaps with end-users, who are working with only 1 or 2 stable files, it's not such a problem, but if you (or the user) copy or rename the database, make sure you change the name in the Application Title also.

ssharkins
ssharkins

Thanks for the addition info!

ssharkins
ssharkins

Thanks -- no clue, but fixed.

ssharkins
ssharkins

The icon file has to be an icon file -- it won't work with other graphic types.

rw2000
rw2000

See separate post. Sorry, I posted to the wrong spot.

Editor's Picks