By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Disable macros?

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Billy R. Moon wrote:
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.


Distribute an .MDE version of your database?
--
regards,

Bradley
Nov 13 '05 #2

P: n/a
We need to disable the capability for ALL databases, not just 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.

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:jb****************@news-server.bigpond.net.au...
Billy R. Moon wrote:
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.


Distribute an .MDE version of your database?
--
regards,

Bradley

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.