Results 1 to 5 of 5

Thread: Disable macros?

  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: Disable macros?

    Has anyone ever come up with a way to disable macro creation within MS Access? Not just on a project level, but to prevent macros from being created and/or ran on a particular PC or by a particular user.

    It doesn't really matter whether macros can still be ran, just need to prevent certain users from being able to create them. (Or vice versa, if they can create macros but not run them, that accomplishes the same thing). The kicker is that there is VBA code in some of our apps that will still need to run.

    I'm asking in particular about Access XP, but I'd love to hear from anyone that's been able to pull it off in any version.

  2. #2
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    Not sure about disabling the macro's, but you could set the startup properties so that no menu's are available and set it to bypass the shift bypass key

  3. #3
    Join Date
    May 2004
    Posts
    2
    We really need to disable the capability on any Access database on a particular PC (or for particular user), not just specific projects.

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Change the system.mdw file on that pc and take away macro rights for user admin. Make sure to create a username in that workgroup with full rights first.

    If you're using different mdw files for different dbs, you'll need to change the rights of that user(s) in each one.

  5. #5
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    I would personally just create .mdw's for all of the Databases that way you can have full control over who can do what

    I hope this helps some,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •