Rename an Access file

Microsoft Office Access 2003

previous page next page
  • Close the Microsoft Access file. If you are using an Access database in a multiuser environment, confirm that all users have closed the file.
  • Click Open Button image on the toolbar.
  • In the Open dialog box, locate the Access file you want to rename, and then right-click the file.
  • On the shortcut menu, click Rename.
  • 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.

    Show Tip

    You can also rename an Access file from outside Access. Close the file, right-click the file in My Computer, and then click Rename on the shortcut menu.

    previous page start next page