Solved

MS ACCESS Backup Goes to Wrong Default Folder

Posted on 2013-11-20
4
322 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 84
ID: 39664223
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
ID: 39666057
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
ID: 39667165
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
ID: 39667264
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

734 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