Disable macros?

[Billy R. Moon]

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.

 

[Steve Schapel]

Billy,

In most cases, converting the application to MDE format would generally
take care of this. If the user still has access to the Database Window,
they could still create a macro, but since almost always a macro is
assigned to an event on a form or report, and since form or report
design mode is not available in an MDE, actually using a macro is pretty
much out. One step further would be to make the Database Window
unavailable, which it probably should be in any case, and this
effectively prevents macro creation.

 

[Billy R. Moon]

Thanks, but what I'm really after is a way to disable macros across all
databases rather than for a particular project. The idea is to prevent
non-programmers from being able to create 'applications' using macros that
will be difficult to maintain.

 

[Steve Schapel]

Billy,

I don't know of any way to do what you ask. But in any case, I'm sorry,
I don't understand. Disabling macros is not going to prevent the
creation of difficult-to-maintain applications, in fact it's got nothing
to do with it.