Welcome to SPN

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

Sign Up Now!

Subform not displayed unless database owner

Discussion in 'Information Technology' started by joan.edington@btopenworld.com, Jul 28, 2006.

  1. joan.edington@btopenworld.com

    Guest

    Hi,

    I have an Access 2003 DB which has a form and linked subform. I
    designed the DB with no security and had no problems. However, when I
    tied the security down to only allowing myself design permissions and
    everyone else restricted ones, my own user with permissions to do
    absolutely everything has a problem. The subform does not display. It
    does if anyone else uses the DB.

    What may sound odd is the way I have security set up. Several members
    of staff have their own simple databases and there is no corporate
    Access Workgroup security in place. Since the default user is admin, I
    have left everyone using that. In my own copy of the workgroup file I
    have my own user as well as admin. I have changed things round so that
    I have all the permissions and admin is restricted.

    When the database was created, admin was the owner and I can't change
    it.

    Only admin can now see the subform although that user has less
    permissions than me.

    Can anyone please give me a clue as to why this is happening and,
    hopefully, how to get round it?

    Thanks.

    Joan
     
  2. Loading...

    Similar Threads Forum Date
    UK Never-displayed rare Sikh chain armour to be restored Breaking News Sep 29, 2010

  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    <joan.edington@btopenworld.com> wrote

    > I have an Access 2003 DB which has a form and linked subform. I
    > designed the DB with no security and had no problems. However, when I
    > tied the security down to only allowing myself design permissions and
    > everyone else restricted ones, my own user with permissions to do
    > absolutely everything has a problem. The subform does not display. It
    > does if anyone else uses the DB.
    >
    > What may sound odd is the way I have security set up. Several members
    > of staff have their own simple databases and there is no corporate
    > Access Workgroup security in place. Since the default user is admin, I
    > have left everyone using that. In my own copy of the workgroup file I
    > have my own user as well as admin. I have changed things round so that
    > I have all the permissions and admin is restricted.
    >
    > When the database was created, admin was the owner and I can't change
    > it.
    >
    > Only admin can now see the subform although that user has less
    > permissions than me.
    >
    > Can anyone please give me a clue as to why this is happening and,
    > hopefully, how to get round it?


    Your somewhat unorthodox approach to securing the database has, as you seem
    to have realized, created the problem for you. But, can you not change the
    owner simply by creating your own blank DB, under your security workgroup,
    and importing all the objects from the original?

    Larry Linson
    Microsoft Access MVP
     

Share This Page