Global Settings for New Users???

[Guest]

Whenever a new user logs onto an XP machine and gets a new profile, I have to
go into their MS Access and clear some check boxes in their options in
access. The Options have to do with Confirmations in the TOOLS , OPTIONS MENU
, under the EDIT/FIND Tab.... I need to clear the boxes in the CONFIRM for
RECORD CHANGES, DOCUMENT DELETIONS and ACTION QUERIES.

Does anyone know how to make these changes global so that if anyone in the
future is using Access on a PC, they will not have to remove the checks in
the boxes?

Thanks
R

 

[Guest]

You could just open the database with something like DoCmd.SetWarnings =
False on the on open even of a form. Of course that might do more than you
wish.

Check out Application.SetOption. Below are some I use in A97 databases.

'Set some database defaults found in Tools, Options
' Put in the Open event of the startup form
' Set Default Locking to Edited Record
Application.SetOption "Default Record Locking", 2
' Set Default Open Mode for Databases to Shared
Application.SetOption "Default Open Mode for Databases", 0
' Set Default Find/Replace Behavior to Start of Field Search
Application.SetOption "Default Find/Replace Behavior", 2

In the case of "Application.SetOption "Default Record Locking", 2" Default
Record Locking has three choices and the one I want is the third so, of
course, I put in 2 for the arguement. That's because it starts numbering at 0
instead of 1.

Put the above code in the Open Event of your opening form. One other strange
thing is that the database may need to be opened and closed twice on the
user's computer for the change to take effect. The first time the database
opens, it makes the changes. The second time the changes are in effect.