Results 1 to 12 of 12
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security (Access 2000)

    Hello Access Gurus,

    I have applied security to one of my databases - Created Workgroup, Set up accounts, groups and users etc and everything is working well for this secured database. However, I am wondering about the other databases that don't have security. I now have to supply a name and password to each of my databases even though they don't have security. Is there any way that I can get around this? I don't want to have to supply a name and password to all my databases.

    Cheers,

    Jocelyn

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Security (Access 2000)

    You created and joined a new workgroup file, so that you now open ALL databases with this workgroup file. To avoid this, you should join the standard workgroup file System.mdw again. You will be able to open unsecured databases without logging in then. Create a shortcut for each secured database you have. Its target should look like this:

    "C:Program FilesMicrosoft OfficeOfficeMSAccess.exe" "C:AccessMyDatabase.mdb" /wrkgrp "C:AccessSecure.mdw"

    Of course, you must substitute the appropriate paths and file names.

    If you have secured the database according to all the rules, you have removed the Admin user from the Admins group, and have taken away most permissions from Admin. So if anyone starts your secured database directly, without using the shortcut, (s)he will open it as Admin, and not be able to do much. Only by opening the database using the shortcut will (s)he be able to login as a user with custom permissions.

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Access 2000)

    I have secured some databases this way but without eliminating the Admin users group and permissions and it seems to work fine. But I have one question - will someone be able to open the database directly if I have secured the database without doing this? I tried to open the database directly just to be sure and I get a message saying that "You do not have the neccessary permission to use the [Database path] object. Have the system administrator or the person who created this object establish the appropriate permissions for you."

    Am I OK or will someone still be able to get in somehow?

    Thanks,
    Eric

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Security (Access 2000)

    Whoa, you can't eliminate the Admins group, nor should you revoke permissions from it.

    The idea is to remove the Admin user from the Admins group, and to take away most permissions from this user, because if somebody opens a database without using the secured workgroup file, (s)he automatically logs in as the Admin user. From the error message you get, I'd say that this has been done correctly for your database.

  5. #5
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Access 2000)

    OK, I see. Thanks for the help.

    Eric

  6. #6
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Access 2000)

    Thanks Hans,

    As I have said in the past, your blood is worth bottling!

    I created the shortcut and re-joined the standard workgroup file and all databases are working well. I wonder why it hasn't been included in the book I was following for this process - I was using QUE's Special Edition Using Microsoft Access 2000 and could not find a reference to this importance info.

    Thanks again,

    Jocelyn

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Security (Access 2000)

    That book is more or less an intermediate level book and doesn't touch on dozens of topics of interest to serious Access developers - we usually recommend the Access Developer's Handbook - do a search on Amazon for the version you work with - 2000 and up are 2 BIG volumes, and I personally like Alison Balters' set for 2002. Then of course there are all the MSKB articles - there is a very good white paper by Microsoft on security, and we have a brief tutorial that looks at it from a concepts perspective - not sure the bit about the command line is in there either - I may update it if it isn't. Finally there's the Lounge where we hang out that is an excellent resource.
    Wendell

  8. #8
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Access 2000)

    Thanks Wendell,

    Much appreciated.

    Cheers,

    Jocelyn

  9. #9
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Access 2000)

    Thanks kindly for this, I found it very informative. By the way, pardon my ignorance, but what does FWIW stand for?

    Cheers,

    Jocelyn

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Security (Access 2000)

    Jack will probably be asleep by now, so I'll answer.

    FWIW = for what it's worth

    It is one of the many abbreviations used on the internet; some others are

    BTW = by the way
    HTH = hope this helps
    IMO = in my opinion
    IMHO = in my humble opinion
    OTOH = on the other hand
    TIA = thanks in advance

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Access 2000)

    FWIW, I have written a paper on Access security. You can find it at
    http://www.geocities.com/jacksonmacd

    <font color=blue>Edited by WendellB to activate link</font color=blue>
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Security (Access 2000)

    A very nice paper - would you mind if we created a link to it in our security tutorial?
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •