Making an Access Database Taskbar Item


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Access Archon Column #237

By Helen Feddema

Access versions: 2007-2013

Level:  Intermediate

The Problem

Back in Access 2003 and Windows XP, it was easy to make a shortcut to open a specific Access database – just right-drag the database from an Explorer pane to the Quick Launch area of the taskbar.  But if you try to do this with Windows 7 or higher, all that happens is that the database is pinned to the Jump menu of the main Access taskbar icon:

AW 1701-A

The Solution

Windows 7 doesn’t have a Quick Launch toolbar, but I found a way to get a database shortcut onto the taskbar, as some people like (personally, I like the Jump menu just fine); it should work in Windows 8 as well.  In short, I made a new toolbar, added one item to it, and made the title and database name invisible, so only the Access icon showed.  Then the user can click this item (actually the first and only item in a toolbar) to open the database.  Here are the steps in detail:

  1. Create a folder for the new toolbar – I made one called Taskbar Items under the default folder for my user name.
  2. Right-drag the database to the new folder, and select Create Shortcut Here from the context menu when dropping it.
  3. Edit the shortcut name as desired.
  4. Right-click the taskbar and select New toolbar…
    AW 1701-B
  5. Select the Taskbar Items toolbar:
    AW 1701-C
  6. The new toolbar appears on the right side of the taskbar, with the toolbar name displayed:
    AW 1701-D
  7. Unlock the Taskbar if it is locked:
    AW 1701-E
  8. Right-click the toolbar name and uncheck the Show Text and Show Title items:
    AW 1701-F
  9. Now you will see a small Access icon representing the database, that you can click to open the database, just as in Windows XP:
    AW 1701-G
subs profile e1563205311409 - Making an Access Database Taskbar Item
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address