Access: Change the Default Folder

When you first install Microsoft Access, it makes an assumption about where you’d like to save your databases when you first create them. If you’re using Windows 7, you’re likely to find that it’s defaulted to your user ‘Documents’ folder. If you have a different location you’d rather it default to, however, that can be changed.

It doesn’t matter if you have a database open or not, but you’ll need to have the Access application open. Go to the ‘File’ tab on the ribbon, and choose ‘Options’. If it’s not already selected, make sure you have the ‘General’ button pressed (from the options on the left-hand side of the window). In the ‘Creating Databases’ section, you can enter a new file path for your default save location next to ‘Default database folder:’. Click the ‘Browse…’ button if you’d like to navigate to it instead of entering it manually. When you’re done, press the ‘OK’ button.

It’s important to note that this doesn’t change the location of any databases you’ve already created; it simply changes the default for any that you create from this point forward.


Post a Comment