Create a shortcut to an Access file in the Favorites folder
The Favorites folder stores shortcuts to folders and files you use frequently, including those in remote locations, so that you don't have to search for the files each time. The original file or folder doesn't move when you create a shortcut to it.
- Click Open on the toolbar.
- To create a shortcut to a folder, subfolder, Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.), or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) that appears in the list under the Look in box, select the file or folder, click Tools, and then click Add to Favorites.
Create a shortcut to open an Access file or database object
You can create a shortcut to open a database object (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.) in a Microsoft Access file (Microsoft Access file: A database or project file. In Access 2007, database objects and data are stored in .accdb files. Earlier versions use.mdb files. An Access project file doesn't contain data, and is used to connect to a SQL Server database.) that is stored locally on your computer or remotely on a network file server or in a shared directory.
- Under Objects in the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click the type of database object you want to create a shortcut for.
- Right-click the object, and then click Create Shortcut.
- If you want the shortcut to go to a location other than the desktop, type a new path in the Location box, or click Browse to choose the location and have Access fill in the path for you. For example, you might want to store the shortcut in the Favorites folder, which stores shortcuts to items you use frequently.
If you're creating a shortcut for an object in a database that is on a network, Access selects This Database is on the Network, and fills in the network path in the Full Network Path box. If you move the database later, you can type in a new network path in this format:
With the network path specified, you can, for example, send the shortcut through e-mail so that others with access to the network can use the shortcut, too.
- Click OK.
When you double-click the shortcut, Access opens the database in which the object is stored and displays the object. A shortcut to a macro (macro: An action or set of actions that you can use to automate tasks.) or stored procedure runs that macro or stored procedure. To open the object in a specific view, right-click the shortcut, and then click the view you want.
- If you move the database after you create the shortcut, delete the shortcut and create a new one.
- To delete a shortcut, click it and then press the DELETE key. Deleting the shortcut does not delete the object that the shortcut opens.
You can also drag the object from the Database window to the desktop or to a folder. Make sure the place you want to drag the shortcut to is visible. (If you previously maximized the Access window, minimize it enough to show the desktop or the folder where you want to place the shortcut.)