Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page