Removing the Workgroup Admin in Access XP

[DS]

Not sure if this post should go into Security or Install + Config. In Access 97 you could stop users having access to the workgroup administrator my removing the wrkgadm.exe file. In Access 2002 the workgroup administrator is built in to the database menu. I can remove this + other menu items by customising the database menu the problem is I would have to go to every users PC to do this. The users install Access via MSI - is there a way to install Access with the customsed database menu

TIA

David

 

[Lynn Trapp]

You need to create custom menus that are part of the database, rather than
customizing the default menu. Then you would need to designate which menu
each form or report in your application is to use.

--
Lynn Trapp
MS Access MVP
(e-mail address removed)
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Not sure if this post should go into Security or Install + Config. In

Access 97 you could stop users having access to the workgroup administrator
my removing the wrkgadm.exe file. In Access 2002 the workgroup
administrator is built in to the database menu. I can remove this + other
menu items by customising the database menu the problem is I would have to
go to every users PC to do this. The users install Access via MSI - is
there a way to install Access with the customsed database menu?

 

[DS]

I would create a set of custom menus for an application but in this case I would like to remove the workgroup administrator from the default database menu when installing Access itself (as part of an Office XP install). As I stated in my previous post, in Access97 you could remove the WKGADM.EXE file to prevent the users accessing the workgroup administrator. With Access XP when you install it the workgroup administrator is on the database menu. Office XP is installed by using an MSI, is there anyway of modifiying the MSI or creating a custom MSI so that the workgroup administrator is disabled for users?

 

[Joan Wild]

I would create a set of custom menus for an application but in this
case I would like to remove the workgroup administrator from the
default database menu when installing Access itself (as part of an
Office XP install). As I stated in my previous post, in Access97 you
could remove the WKGADM.EXE file to prevent the users accessing the
workgroup administrator.

I don't believe this is possible. Could you explain why you want to do
this? What possible harm could be done by having it there?

 

[DS]

It is possible to remove any item from the built in menus when Access XP is installed (including Workgroup administrator and security features). The problem we have is that users have Access XP as part of their standard Office setup i.e. everyone in the organisation has it. Therefore a large number of users create their own databases then expect technical support from IT when they experience problems with DBs they've created. If the users start creating their own MDW files it makes supporting their databases more difficult. However, Access applications developed by IT are created with custom menus and security as they are shared across departments

I could go around to every users PC and remove the offending items from the built in menus but as we have automated the Office install (using MSI) it would be preferrable to automate the removal of the menu items.