Saving current settings in Access

[Guest]

I copied a database on a CD that will be distributed to many users. I want
to make sure that the current Access settings remain static such as hidden
tool bars and disable message prompts for delete queries, appends,etc. Is
there a setting in Access that will save the current views and settings or do
I need to apply code as application load?

Thanks,
Matt

 

[Douglas J. Steele]

It depends what specific settings. Some belong to the database, while some
belong to Access.

In general, if you set the property through Tools | Startup, it belongs to
the database, while if you set it through Tools | Options, it belongs to
Access.

 

[Joseph Meehan]

Well if they keep it on the CD then there will not be any problems as
they will not be able to change anything including the data.

You may want to try user level security

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.