Re: Newbie: MS Access Security FAQ question

I would suggest that you take a look at the simplified list of 10 steps you
need to follow, as they are listed in my website. You can get to it from the
link below to the Security page on my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



"A C" <no@xxxxx> wrote in message
news:9_h0f.15843$iM2.1295662@xxxxxxxxxxxxxxxxxx
> Hello.
>
> I am totally new to Access security. I am reading the MS Access Security
> FAQ
> (http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fconten
> t%2Fsecfaq.asp) and point 10 says something about importing all objects
> into
> a new database because there is a bug in MS Access wrt Open/Run
> permissions,
> and that this should be done early before we start setting up new users
> and
> permissions on objects etc as otherwise we may loose this info.
>
> This may seem like a dumb question, but do I have to secure the new
> database
> first in the same way as I secured my "master" database? And when do I do
> the importing? Or how does this work?
>
> The steps I am told to do is (roughly)
> a. create the mdw file
> b. create a new "master" user in my database and add it to the admin
> group,
> and move the default admin user into the Users group.
> c. select the objects to secure in my database, run the wizard to encrypt
> the dbase.
> d. create new groups as required, and then add users and asign them to
> these
> groups as required
>
> At what stage in the above steps should I do the importing?
> Do I need to to repeat steps a and b in the new database, and then import
> the items into that and then do steps c and d? Do I have to set the users
> up all again? , or do I import between step c and d? If I do it after
> step
> d do I then have to reapply my permissions and restrictions to the users
> in
> my new database?
>
> All help appreciated
> AC
>
>


.

Relevant Pages

  • Re: How to add 3 levels of access to a database
    ... >created a secure version of my database with a shortcut ... http://www.geocities.com/jacksonmacd/ for info on MS Access security ...
    (microsoft.public.access.security)
  • Re: Bulletproofing database with .mde file
    ... malicious intent who is also a legitimate user of your database (ie. has the required folder ... "Normal users (in any workgroup file) will not be able to change the setting." ... that Access security simply raises the bar. ... John made no indication that his database was secure, ...
    (microsoft.public.access.security)
  • Re: Bulletproofing database with .mde file
    ... malicious intent who is also a legitimate user of your database (ie. has the required folder ... "Normal users (in any workgroup file) will not be able to change the setting." ... that Access security simply raises the bar. ... John made no indication that his database was secure, ...
    (microsoft.public.access.gettingstarted)
  • Re: Password HELP!!!!!!!
    ... > administrative account, and then am able to open databases ... > prompt for all ... >>Access Security: www.ltcomputerdesigns.com/Security.htm ... >>> of an extra database so I couldn't screw anything up, ...
    (microsoft.public.access.gettingstarted)
  • Re: Adding a database to existing workgroup file
    ... I was reading about splitting a database on your site just before I opened ... I think I'm going to have to study Access security in more depth using the ... > links to the tables in the backend. ... > the frontend exclusively to make design changes.) ...
    (microsoft.public.access.security)