Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

how do you add or change Permissions in a DB

Discussion in 'Information Technology' started by luv2bike2, Jul 28, 2006.

  1. luv2bike2

    luv2bike2
    Expand Collapse
    Guest

    I am very new to Access 2003 (for that matter to DB's Period). Any way I
    have inherited this DB and now a user is having a problem with accessing all
    the things she was able to access just this morning. When she double clicks
    on the DB she needs to open, it usually prompts her for her login and
    password. She does not get prompted for it but it goes right into the DB and
    she can go to where she needs to go to, however when she clicks on "Add New
    PPT" it tells her that she does "not have permission to access the
    Documention functions. Please use the "find a Document" button above."

    I can logon to her workstation as the administrator and than double click
    the DB and I get asked for a log in and password and I can do what ever she
    needs to be done.

    I dont' know why all of a sudden she is having this problem. Nothing has
    changed. no updates to MS was performed or nothing added to her workstation,
    nothing deleted, it is all too weird.

    My question is where and how do i check and change for permissions. i asked
    the person who took I took this job over from a while back how to set
    permissions however, the response i got was there is a block of code behind
    one of the forms that is used to grant Documentation write access. it's a
    block with user names. that i have to find it and change one of the names.
    all well and good, but i don't know where to look to find it. Can anyone
    help me out here. I looked through the Access help but i guess i am not
    putting in the rigth search words. Much appreciated in advance.

    --
    Thank you,
     
  2. Loading...


  3. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    mdb security is crap disable it and upsize your important data to SQL
    Server.

    i reccomend using Access Data Projects.
     
  4. luv2bike2

    luv2bike2
    Expand Collapse
    Guest

    here what I know about the DB.
    users can get into the db with out a password. however there is one user
    that needs to have a password because she can do things that other users can
    not do.
    some how (and I can not explain it) when she logs in the log in screen for
    that DB is gone for her. she says that she can go in and do her thing
    now--she found a work around. Other users get the log on screen however they
    do not have to put a password in. they can go in and i am assuming do
    queries and can not make any changes.
    what do i need to do to get the log on screen for this user to come back?
    --
    Thank you,



    "luv2bike2" wrote:

    > I am very new to Access 2003 (for that matter to DB's Period). Any way I
    > have inherited this DB and now a user is having a problem with accessing all
    > the things she was able to access just this morning. When she double clicks
    > on the DB she needs to open, it usually prompts her for her login and
    > password. She does not get prompted for it but it goes right into the DB and
    > she can go to where she needs to go to, however when she clicks on "Add New
    > PPT" it tells her that she does "not have permission to access the
    > Documention functions. Please use the "find a Document" button above."
    >
    > I can logon to her workstation as the administrator and than double click
    > the DB and I get asked for a log in and password and I can do what ever she
    > needs to be done.
    >
    > I dont' know why all of a sudden she is having this problem. Nothing has
    > changed. no updates to MS was performed or nothing added to her workstation,
    > nothing deleted, it is all too weird.
    >
    > My question is where and how do i check and change for permissions. i asked
    > the person who took I took this job over from a while back how to set
    > permissions however, the response i got was there is a block of code behind
    > one of the forms that is used to grant Documentation write access. it's a
    > block with user names. that i have to find it and change one of the names.
    > all well and good, but i don't know where to look to find it. Can anyone
    > help me out here. I looked through the Access help but i guess i am not
    > putting in the rigth search words. Much appreciated in advance.
    >
    > --
    > Thank you,
    >
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    luv2bike2 wrote:
    > I am very new to Access 2003 (for that matter to DB's Period). Any
    > way I have inherited this DB and now a user is having a problem with
    > accessing all the things she was able to access just this morning.
    > When she double clicks on the DB she needs to open, it usually
    > prompts her for her login and password. She does not get prompted
    > for it but it goes right into the DB and she can go to where she
    > needs to go to, however when she clicks on "Add New PPT" it tells her
    > that she does "not have permission to access the Documention
    > functions. Please use the "find a Document" button above."
    >
    > I can logon to her workstation as the administrator and than double
    > click the DB and I get asked for a log in and password and I can do
    > what ever she needs to be done.
    >
    > I dont' know why all of a sudden she is having this problem. Nothing
    > has changed. no updates to MS was performed or nothing added to her
    > workstation, nothing deleted, it is all too weird.
    >
    > My question is where and how do i check and change for permissions.
    > i asked the person who took I took this job over from a while back
    > how to set permissions however, the response i got was there is a
    > block of code behind one of the forms that is used to grant
    > Documentation write access. it's a block with user names. that i
    > have to find it and change one of the names. all well and good, but i
    > don't know where to look to find it. Can anyone help me out here. I
    > looked through the Access help but i guess i am not putting in the
    > rigth search words. Much appreciated in advance.


    Take a look at the properties of an icon on another's computer to see
    what the string is to the workgroup file. Fixing the one on the machine
    that is having problems should take care of it.

    In the mean time you should do some reading on the complex subject of
    Access Security. You also need to make sure you have the administer access
    to the database to make changes

    I suggest you start by reading
    http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

    Access security is a great feature, but it is, by nature a complex product
    with a very steep learning curve. Properly used it offers very safe
    versatile protection and control. However a simple mistake can easily lock
    you out of your database, which might require the paid services of a
    professional to help you get back in.

    Practice on some copies to make sure you know what you are doing.

    --
    Joseph Meehan

    Dia duit
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    aaron.kempf@gmail.com wrote:
    > mdb security is crap disable it and upsize your important data to SQL
    > Server.
    >
    > i reccomend using Access Data Projects.


    Get a life man.

    --
    Joseph Meehan

    Dia duit
     
  7. luv2bike2

    luv2bike2
    Expand Collapse
    Guest

    Thank you very much for your input. I found the workgroup and made the
    change on the users system and now i will read up Access Security and set the
    security settings for this users. this was of great help! :)
    --
    Thank you,



    "Joseph Meehan" wrote:

    > luv2bike2 wrote:
    > > I am very new to Access 2003 (for that matter to DB's Period). Any
    > > way I have inherited this DB and now a user is having a problem with
    > > accessing all the things she was able to access just this morning.
    > > When she double clicks on the DB she needs to open, it usually
    > > prompts her for her login and password. She does not get prompted
    > > for it but it goes right into the DB and she can go to where she
    > > needs to go to, however when she clicks on "Add New PPT" it tells her
    > > that she does "not have permission to access the Documention
    > > functions. Please use the "find a Document" button above."
    > >
    > > I can logon to her workstation as the administrator and than double
    > > click the DB and I get asked for a log in and password and I can do
    > > what ever she needs to be done.
    > >
    > > I dont' know why all of a sudden she is having this problem. Nothing
    > > has changed. no updates to MS was performed or nothing added to her
    > > workstation, nothing deleted, it is all too weird.
    > >
    > > My question is where and how do i check and change for permissions.
    > > i asked the person who took I took this job over from a while back
    > > how to set permissions however, the response i got was there is a
    > > block of code behind one of the forms that is used to grant
    > > Documentation write access. it's a block with user names. that i
    > > have to find it and change one of the names. all well and good, but i
    > > don't know where to look to find it. Can anyone help me out here. I
    > > looked through the Access help but i guess i am not putting in the
    > > rigth search words. Much appreciated in advance.

    >
    > Take a look at the properties of an icon on another's computer to see
    > what the string is to the workgroup file. Fixing the one on the machine
    > that is having problems should take care of it.
    >
    > In the mean time you should do some reading on the complex subject of
    > Access Security. You also need to make sure you have the administer access
    > to the database to make changes
    >
    > I suggest you start by reading
    > http://support.microsoft.com/default.aspx?scid=kb;[LN];207793
    >
    > Access security is a great feature, but it is, by nature a complex product
    > with a very steep learning curve. Properly used it offers very safe
    > versatile protection and control. However a simple mistake can easily lock
    > you out of your database, which might require the paid services of a
    > professional to help you get back in.
    >
    > Practice on some copies to make sure you know what you are doing.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  8. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    Joseph

    speak english {censored word, do not repeat.}nut
     

Share This Page