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

Posted on 2009-04-24
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

    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.
    LVL 1

    Author Comment

    by:Lou Dufresne
    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    737 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

    16 Experts available now in Live!

    Get 1:1 Help Now