Show All

Hide All

1. Close the Microsoft Access file (Microsoft Access file: An Access database or Access project file. An Access database stores database objects and data in an .mdb file. A project file doesn't contain data and is used to connect to a Microsoft SQL Server database.). If you are using an 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. The Microsoft Jet database engine manages the data.) in a multiuser (multiuser (shared) database: A database that permits more than one user to access and modify the same set of data at the same time.) environment, confirm that all users have closed the file.
2. Click Open on the toolbar.
3. In the Open dialog box, locate the Access file you want to rename, and then right-click the file.
4. On the shortcut menu, click Rename.
5. Type the new name. Include the .mdb or .adp extension only if you've set up Microsoft Windows to display file extensions for known file types. Press ENTER.

Notes

• A file name can be up to 215 characters, including spaces.

• If you rename a Microsoft Access database, and another database includes links to objects in that database, use the Linked Table Manager in the other database to update the link information. Otherwise, Access will produce an error when you try to use those linked objects in the other database.

Tip