Looking for way to deny access to VBA & VB Editor

[Chris V.]

Hi,

I have Access 2000 deployed, and we're looking for solution to Block access
to VB editor & VBA under Access (without avoiding macros to run when they
are already in a DB).

I've using the Template ACCESS9.ADM for AD to disable the Tools | Macro menu
as well as the Shortcut, but if I create a new module in a DB, I can still
write macros.

Is there any way to disable this (preferably through GPO, but if not, any
way to do it will be welcome)

Thanks,
chris

 

[Garret]

What is your end goal here - Why are you trying to disable this? Are
you trying to create a more user-friendly interface where users can't
do anything?

 

[Chris V.]

Hi,

Goal is mainly securing at much as possible (close to paranoia ).
so, they have to use the macro properly developped by the dedicated team,
but NOT to be able to even see the code, not create macro.

(This thing is a part of more global project of closing down Office and have
a full control about what can and can't be done by users).

Chris

 

[Garret]

Hm? So you want users to be able to create macros but not write code?

 

[Chris V.]

Nope, to run macros written before (through proper set of buttons whatever),
but not to writte antyhing themselves

 

[Norman Yuan]

Depoly *.mde to users instead of *.mdb.

 

[Garret]

Like Norman said, you can create .mdes for all your users to use, or
you can set up the Security system so people have accounts and
usernames. (.mde is easier but you may need the Security system too)

 

[Tony Toews]

Goal is mainly securing at much as possible (close to paranoia ).
so, they have to use the macro properly developped by the dedicated team,
but NOT to be able to even see the code, not create macro.

(This thing is a part of more global project of closing down Office and have
a full control about what can and can't be done by users).

I'd have to agree with the paranoia thing. <smile> What damage can
they do? Update/delete records they're not supposed to? Yes, that's
quite possible especially if they can get to the table view window.
Delete files? They can use Windows Explorer for that.

After all if your users can't use Access to manage data then they'll
use Excel. <shudder> And if they can't use Excel they'll use Word.
Or Notepad.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm