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
Solved

MS ACCESS Backup Goes to Wrong Default Folder

Posted on 2013-11-20
4
320 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
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

860 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