hiding toolbars etc...

[Brad Pears]

I have a basic question. We have an Access 2000 application that we have
removed the ability for a user to get to the DB window (have to use SHIFT
key to get there). I have recently made changes to the app and copied my new
..mdb file over to production. Now, all of this is available again to the
standard user! I just wonder where all of these particular settings are
stored. I suspect that anytime any programmer modifies the .mdb on their own
local PC and then reposts to production, it will pick up the settings from
that user's PC correct?..which would then overwrite the settings on the .mdf
in the production area? If I create default toolbars etc... where is that
info stored and how can we make sure that that data stays with the .mdf so
that when changes are made, it will always pick up those partiucular
'startup' settings?

Thanks,

Brad

 

[Joan Wild]

I have a basic question. We have an Access 2000 application that we have
removed the ability for a user to get to the DB window (have to use SHIFT
key to get there). I have recently made changes to the app and copied my new
.mdb file over to production. Now, all of this is available again to the
standard user!

Is it possible that you made the changes on a copy of the database that
didn't have the startup settings in place?

I just wonder where all of these particular settings are
stored.

In the database (mdb) file, well most....

I suspect that anytime any programmer modifies the .mdb on their own
local PC and then reposts to production, it will pick up the settings from
that user's PC correct?..

It depends on what settings. You are referring to toolbars/menubars. If
you create new ones, those are stored with the mdb. If you instead modify
any of the built-in ones, then that is stored/only affects your copy of
Access.

which would then overwrite the settings on the .mdf
in the production area? If I create default toolbars etc... where is that
info stored and how can we make sure that that data stays with the .mdf so
that when changes are made, it will always pick up those partiucular
'startup' settings?

Ensure you are creating new menu/toolbars. You can always double-check the
settings in Tools, Startup (these are stored in the mdb) before you copy to
production.