Preventing users from being able to create new macros, policy leve

[Christofolous]

I would like to be able to prevent users from creating new macros but not
prevent them from running existing ones. I can disable access to the Macros
option in the Toolbar and Menubar, but access to Macros is still available
from the list of objects when they create a new database (along with other
objects such as Tables, Queries, Forms, etc).

Is there a way that I can hide or prevent access to the Macro option at a
policy level without preventing existing macros from running for any access
database file that is opened or created?

Cheers

Chris

 

[Steve Schapel]

Chris,

In my experience, it is standard procedure for users to not have access
to the Database Window. This is set up via the Tools|Startup menu.
That way, they can't create or modify macros.