Access 2000 Menu customization

[daniel.sumanth]

Hello,
Have customized the menu options in Access 2000 in a computer. However,
it seems that the customizations apply only when I'm logged in and not
to other users. Is there any way to use the customizations as a default
for all users of Access on that computer.
Thanks

[Albert D. Kallal]

If you customize "your" menus, then they only apply to you. So, if you are
building an application, and want the menus to go with the application, then
you need to build NEW custom menus, and NOT USE the built in ones.

The process of customizing new menus is the same.

I have a sample application that has all of the ms-access interface hidden.
(this was accomplished by using the tools->startup options, and a few
menus). Give the following download a try, and then take a look at the
settings I used:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

Grab the 3rd example (ms-access interface hidden).

So, the above is a great way to hide all of ms-access, and not have to write
code, or use security.

Also, here is some more screen shots of ms-access menus, and also some ideas
as to when/why to using menus

http://www.members.shaw.ca/AlbertKal...erFriendly.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal

[Albert D. Kallal]

If you customize "your" menus, then they only apply to you. So, if you are
building an application, and want the menus to go with the application, then
you need to build NEW custom menus, and NOT USE the built in ones.

The process of customizing new menus is the same.

I have a sample application that has all of the ms-access interface hidden.
(this was accomplished by using the tools->startup options, and a few
menus). Give the following download a try, and then take a look at the
settings I used:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

Grab the 3rd example (ms-access interface hidden).

So, the above is a great way to hide all of ms-access, and not have to write
code, or use security.

Also, here is some more screen shots of ms-access menus, and also some ideas
as to when/why to using menus

http://www.members.shaw.ca/AlbertKal...erFriendly.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal

[daniel.sumanth]

Thanks Albert...let me try to explain the problem in greater detail.

Have an MS Access 97 database that used to run on NT. Before deploying
this on any machine, used to make a copy of it, Remove the Edit, View &
Insert Menus (by running the Customize applet and dragging/dropping
these 3 menu options over it). After that, run the Startup applet,
uncheck everything except "Display Status Bar" and then generate the
MDE file.

Once we deployed this on a NT box, the only menu options available to
ANY user running the MDE was File, Window & Help.

Now, we've converted this to Access 2000 and trying to deploy this on
Win2000 boxes. When we follow the above procedure, it works as
described above, however only for the user that does the above steps.
When another user logs on & opens up the MDE, Menus File, Edit, View,
Insert, Window & Help are all available.

It looks the the main problem is: the part of running the customize
applet and removing menus is not database or system specific but user
specific. ie. if I'm logged on and use the customize applet as
described above WITHOUT any DB loaded, then the above menus are not
available for any database that I load. When another user logs in the
above 3 menus are available to him.

Hence my original question:
Is there any way to save the profile of having Menu's without Edit,View
& Insert...and use this as a default for all users. I tried copying the
access.pip file from one user to another, but that does not seem to
work.

Appreciate your help, if I should be looking at another way of
achieving the
same objective and open to that as well.
.........
Albert D. Kallal wrote:

If you customize "your" menus, then they only apply to you. So, if you are
building an application, and want the menus to go with the application, then
you need to build NEW custom menus, and NOT USE the built in ones.

The process of customizing new menus is the same.

I have a sample application that has all of the ms-access interface hidden.
(this was accomplished by using the tools->startup options, and a few
menus). Give the following download a try, and then take a look at the
settings I used:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

Grab the 3rd example (ms-access interface hidden).

So, the above is a great way to hide all of ms-access, and not have to write
code, or use security.

Also, here is some more screen shots of ms-access menus, and also some ideas
as to when/why to using menus

http://www.members.shaw.ca/AlbertKal...erFriendly.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal

[daniel.sumanth]

Thanks Albert...let me try to explain the problem in greater detail.

Have an MS Access 97 database that used to run on NT. Before deploying
this on any machine, used to make a copy of it, Remove the Edit, View &
Insert Menus (by running the Customize applet and dragging/dropping
these 3 menu options over it). After that, run the Startup applet,
uncheck everything except "Display Status Bar" and then generate the
MDE file.

Once we deployed this on a NT box, the only menu options available to
ANY user running the MDE was File, Window & Help.

Now, we've converted this to Access 2000 and trying to deploy this on
Win2000 boxes. When we follow the above procedure, it works as
described above, however only for the user that does the above steps.
When another user logs on & opens up the MDE, Menus File, Edit, View,
Insert, Window & Help are all available.

It looks the the main problem is: the part of running the customize
applet and removing menus is not database or system specific but user
specific. ie. if I'm logged on and use the customize applet as
described above WITHOUT any DB loaded, then the above menus are not
available for any database that I load. When another user logs in the
above 3 menus are available to him.

Hence my original question:
Is there any way to save the profile of having Menu's without Edit,View
& Insert...and use this as a default for all users. I tried copying the
access.pip file from one user to another, but that does not seem to
work.

Appreciate your help, if I should be looking at another way of
achieving the
same objective and open to that as well.
.........
Albert D. Kallal wrote:

If you customize "your" menus, then they only apply to you. So, if you are
building an application, and want the menus to go with the application, then
you need to build NEW custom menus, and NOT USE the built in ones.

The process of customizing new menus is the same.

I have a sample application that has all of the ms-access interface hidden.
(this was accomplished by using the tools->startup options, and a few
menus). Give the following download a try, and then take a look at the
settings I used:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

Grab the 3rd example (ms-access interface hidden).

So, the above is a great way to hide all of ms-access, and not have to write
code, or use security.

Also, here is some more screen shots of ms-access menus, and also some ideas
as to when/why to using menus

http://www.members.shaw.ca/AlbertKal...erFriendly.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal

[Tim Marshall]

da************@gmail.com wrote:

It looks the the main problem is: the part of running the customize
applet and removing menus is not database or system specific but user
specific. ie. if I'm logged on and use the customize applet as
described above WITHOUT any DB loaded, then the above menus are not
available for any database that I load. When another user logs in the
above 3 menus are available to him.

Hence my original question:
Is there any way to save the profile of having Menu's without Edit,View
& Insert...and use this as a default for all users. I tried copying the
access.pip file from one user to another, but that does not seem to
work.

Appreciate your help, if I should be looking at another way of
achieving the
same objective and open to that as well.

HI Daniel,

Actually Albert HAS answered your question succinctly. Others may
disagree, but I don't think it is a good idea at all to modify any of
the default and built-in menus and tool bars that come with Access.

By all means, copy (ctrl-click & drag) specific menu items you desire to
custom toolbars, but it simply is not a good idea to modify the menus
you are proposing,

What you should be doing is deciding what menus and functionality you
wish your users to have and create custom menus that are tied for forms
or the startup dialog you refer to as an "applet".

You can bring menus from one application to another using the advanced
options of file->get external data->import once you specify the mdb.

On cdma, see a similar response I made this evening for RLN on looping
through toolbars.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Tim Marshall]

da************@gmail.com wrote:

It looks the the main problem is: the part of running the customize
applet and removing menus is not database or system specific but user
specific. ie. if I'm logged on and use the customize applet as
described above WITHOUT any DB loaded, then the above menus are not
available for any database that I load. When another user logs in the
above 3 menus are available to him.

Hence my original question:
Is there any way to save the profile of having Menu's without Edit,View
& Insert...and use this as a default for all users. I tried copying the
access.pip file from one user to another, but that does not seem to
work.

Appreciate your help, if I should be looking at another way of
achieving the
same objective and open to that as well.

HI Daniel,

Actually Albert HAS answered your question succinctly. Others may
disagree, but I don't think it is a good idea at all to modify any of
the default and built-in menus and tool bars that come with Access.

By all means, copy (ctrl-click & drag) specific menu items you desire to
custom toolbars, but it simply is not a good idea to modify the menus
you are proposing,

What you should be doing is deciding what menus and functionality you
wish your users to have and create custom menus that are tied for forms
or the startup dialog you refer to as an "applet".

You can bring menus from one application to another using the advanced
options of file->get external data->import once you specify the mdb.

On cdma, see a similar response I made this evening for RLN on looping
through toolbars.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto