When I first started using MS Access and downloading databases I was really confounded when it came to renaming the database. When I tried to use File | Save As, it came up with something other than what I expected or wanted!
Well now I have learned how to accomplish this simple task (it’s always simple once you figure it out, isn’t it?) and I will share my knowledge with you.
All you really need to do is change the name of the .mdb file. You can do this from My Computer or Windows Explorer. You can even do it from Access itself!
Follow the steps below to learn how:
- Close your database file if it is open.
- Click on File | Open.
- Navigate to the File in the open dialog box.
- Right-click the file and select Rename.
- Type a new name for your database.
- Click Enter.
Before you set out to rename your database, remember that MS Access does not automatically update links, so if any other database links to a table in the database whose name you would like to change, you will have to open that other database and redo the links. You would, of course, use the Linked Table Manager to accomplish this.