Disable macros?

message from Billy R. Moon on 27 May 2004

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.

=?Utf-8?B?Um9zY28=?= replied to Billy R. Moon on 27 May 2004

Save and distribute your db as a mde file. A mde file strips out all design capabilities, so users can not create any code or macros, or muck around with your queries. On then Tools menu: Database Utilities/Make mde file.

Just make sure you keep a copy of the mdb file for your self, to make changes and updates. You will not be able to change the mde file.

Hope this helps.
Rosco

Billy R. Moon replied to =?Utf-8?B?Um9zY28=?= on 28 May 2004

Thanks, but I really need to disable the capability for all databases rather
than for particular projects. The idea is to prevent non-programmers from
being able to create 'application' using macros that will be difficult to
maintatin.

"Rosco" <anonymous@discussions.microsoft.com> wrote in message
news:A07F55CD-67DE-4AED-813B-AEC974DF84AE@microsoft.com...
design capabilities, so users can not create any code or macros, or muck
around with your queries. On then Tools menu: Database Utilities/Make mde
file.
changes and updates. You will not be able to change the mde file.

Archived message: Disable macros? (MS Access Forms)