macro security setting keep changing

  • Thread starter Thread starter CC
  • Start date Start date
C

CC

Hi there,

I have a mdb which is shared in our intranet for user to
update it, it works very good for a while. Until
currently, we upgrade part of the users to office 2003,
therfore, some users are in office xp and some are 2003.

The mdb contains some macro, the security setting for it
keep changing to the user who lastly make modification of
it. It end up making some users not able to oppen the mdb
file afterwards. I woudl love to set it to low, since if
it set to med or high, some user just not able to open it
at all..

Are there anyways I can set the macro security setting on
the file,so users cannot change it. But users cna still
have modify right on other areas ?

If there is a way, please please let me know !1

THanks,
CC
 
Macro security is a user or machine setting....it is not specific to the
database. You need to either, get all users to set their macro security to
low, or get a digital certificate and sign your code.
 
Back
Top