MS ACCESS Backup Goes to Wrong Default Folder
Posted on 2013-11-20
I have a database that gets backed up before refreshing each month. The reason it is backed up is to preserve the way it was exactly before the new month's information is added. That way the database doesn't exceed the size limitation, and we always have a way to roll back the current month's changes easily.
The database was apparently copied from another database that is identical except for the location of the source information. The two databases are located in the same file structure, different folders.
Here is the problem.. and it isn't a severe one except lower level analysts and the occasional intern seem to always forget to check before backing up. When I do a back up in the normal way (Office Button>Manage>Back up Database) the folder that it goes to is the folder for the original database that the current copy was made from. Then I have to navigate up a level and back down into the right folder. Like I said, it isn't a big deal, but it often gets done wrong when it isn't me behind the controls.
So far I looked under database properties, and also every tab in Access Options. I'm stumped although I know it is probably something I should know.