Results 1 to 9 of 9

Thread: Securtiy

  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Talking Unanswered: Securtiy

    Morning Gang, I have a MS Project database that has requires user security parameters. I need to setup a Administrator with Full access to the database and users that only limited access to the database. The problem is on the tools menu from the main form I dont have access to any of the options on the tab except set password. please advise.

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Microsoft Access security is a pretty deep subject. Your best bet is to have a look at the Microsoft Knowledge base.

    http://support.microsoft.com/default...&ln=EN-US&FR=0

    Type in the word security and away you go.
    Hope this helps

    David

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Securtiy

    Originally posted by garrydawkins
    Morning Gang, I have a MS Project database that has requires user security parameters. I need to setup a Administrator with Full access to the database and users that only limited access to the database. The problem is on the tools menu from the main form I dont have access to any of the options on the tab except set password. please advise.

    Thanks
    You could do this many different ways ... Thru the Users and Groups permissions or you could do it programmatically ... Take your pick.

  4. #4
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Security

    I cant get access to the usergroups permission. I took over for the developer who is no longer here. He developed the database for one of our user who will serve as the administrator.

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Security

    Originally posted by garrydawkins
    I cant get access to the usergroups permission. I took over for the developer who is no longer here. He developed the database for one of our user who will serve as the administrator.
    Ok. So how do you want to do it?

  6. #6
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Smile Security

    I'd like to do this via the gui utility. How is it activated

  7. #7
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    Re: Security

    Originally posted by garrydawkins
    I cant get access to the usergroups permission. I took over for the developer who is no longer here. He developed the database for one of our user who will serve as the administrator.
    If I am not mistaken, you can replace or use another/empty system db file (SDW), you will be able to take ownership of the objects in the db. For example try using it on a new/different Access installation where the SDW is local/new/standard. I am not quite sure on how this works, but have some info on this somewhere - can have a look if you need more input.

  8. #8
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Thumbs up Security

    Please take a look at what I'm up against

  9. #9
    Join Date
    Oct 2003
    Posts
    706

    Exclamation

    Well, it is pretty much true of any fileserver based database that "the security model is good for preventing people from shooting data in the foot; but it is not sufficient for securing the data."

    Posession, after all, is nine-tenths of the law. In order to use the database I must have at least read access to it. Therefore I can copy it, steal it, unlock it at my leisure. Even if the data file is meaningfully encrypted, I do not need to provide a key to access the data; therefore the key is present but concealed; therefore it can be recovered. Therefore it is a discouragement but not a prevention; hence, not security. The methods of doing this are not even secret: "just download and do it." The 'locks' fall right off.

    If you are securing the data to truly prevent its disclosure, then not only is Access "not it," no fileserver system could be. However... there are a lot of cases where all you really want is for something to go "click!" and not "BANG!" when the barrel is pointed in the wrong direction. For this purpose, Access's scheme (while rather stuffy and baroque and over-engineered) works as good as any in the field.

    (And doesn't Master Locks sell millions of little padlocks that are much, much stronger than the hasps used to attach them to ... umm ... wooden doors, or metal doors in wooden frames? Those padlocks work just fine for the limits and purpose of their application.)
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

Posting Permissions

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