MS Access 2007 - How do I run Manage, BAckUp Database from the Office Button using VBA code

Posted on 2009-04-24
Medium Priority
Last Modified: 2013-11-27
I want to add a button to a form that when clicked the vba code initiates Manage + BackUp Database from the the office button. I want the user to be able to back up the database.

I prevent the user from seeing all the menu choices when they come into the application so this choice is not available to them from the office button.

Thanks for your assistance in advance.
Question by:Lou Dufresne
LVL 16

Accepted Solution

Chuck Wood earned 2000 total points
ID: 24227504
You can add a Back Up Database button to the Quick Access Toolbar at the top left of the Access window by following these steps.
1. Click the Office Button => Access Options.
2. Select Customize from the list on the left.
3. Select All Commands from the Choose commands from drop-down box.
4. Find and select the Back Up Datbase icon in the list.
5. Click the Add>> button in the middle.
6. Click the OK button.

Author Comment

by:Lou Dufresne
ID: 24232353
Perfect. I did not think this would work because I limit the user to not have all menus when they log into the application. However, It does not remove this from the Quick Access Tool bar. This is what I needed

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

578 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