Solved

MS ACCESS Backup Goes to Wrong Default Folder

Posted on 2013-11-20
4
307 Views
Last Modified: 2013-11-21
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.
0
Comment
Question by:Coghan
  • 2
  • 2
4 Comments
 
LVL 84
Comment Utility
Are you asking if there is a way to set the Default location for that operation?

If so, then I don't think you can, but you can try setting the "Default database folder", which is in the Options dialog. You didn't say what version you're using, but in 2010 you'd click Options - General, and the setting is in the "Creating Databases" section.
0
 
LVL 1

Author Comment

by:Coghan
Comment Utility
I thought of that first.  However, the default database folder is set up as

C:\Documents and Settings\myid\My Documents\

Not even the same drive where this database lives.  I guess what I will have to do if I can't change it is create a new database in the folder I want and import all the objects and code. I've been looking through the System  Objects tables and nothing yet.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
I'm using 2010, but I don't get the same behavior.

If I click File - Save As, then select "Backup Database" and click the Save button, the dialog defaults to the folder the database is currently in. I moved one of my test database to a new folder and used the process above, the dialog defaulted to the folder where I had just placed the db.

I made a copy of that database (using standard Windows methods of CtrlC + CtrlV), and then moved that copy to a different folder on a different drive. When I tried to backup, the dialog defaulted to the new folder (not the original folder where the copy was created).

As mentioned, I don't have 2007 so perhaps this was behavior that was resolved in 2010.
0
 
LVL 1

Author Closing Comment

by:Coghan
Comment Utility
As good an answer as I'm going to get.  Gave an A based on the extra effort to test it out.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now