Welcome to SPN

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

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

Permissions - HELP!

Discussion in 'Information Technology' started by Keri, Nov 8, 2005.

  1. Keri

    Keri
    Expand Collapse
    Guest

    Okay here's the deal. I've recently taken over maintenance on several
    databases. The person (owner) who created these databases has left and not
    able to be contacted. Problem I am running into is this. I have a database
    that suddenly stopped working, it will not allow anyone to enter data using
    the form. The only way they can enter data is directly into the table.
    Whenever I go into this database to work on it I get a message stating the
    following "You don't have permission to modify "Commitment Information Form -
    To modoify this object, you must have Modify Design permission for it. If
    the object is a table, you must also have Delete Data and Update Data
    permissions for it. Do you want to open it as read-only?"

    I have a good background in Access, however, I haven't worked alot on the
    whole "Permission" peice of Access. I'm stuck, any help would be appreciated.

    Thanks.
     
  2. Loading...


  3. Ron Hinds

    Ron Hinds
    Expand Collapse
    Guest

    "Keri" <Keri@discussions.microsoft.com> wrote in message
    news:2FB46119-BC34-4FF9-9AE0-06C9423E77FB@microsoft.com...
    > Okay here's the deal. I've recently taken over maintenance on several
    > databases. The person (owner) who created these databases has left and

    not
    > able to be contacted. Problem I am running into is this. I have a

    database
    > that suddenly stopped working, it will not allow anyone to enter data

    using
    > the form. The only way they can enter data is directly into the table.
    > Whenever I go into this database to work on it I get a message stating the
    > following "You don't have permission to modify "Commitment Information

    Form -
    > To modoify this object, you must have Modify Design permission for it. If
    > the object is a table, you must also have Delete Data and Update Data
    > permissions for it. Do you want to open it as read-only?"
    >
    > I have a good background in Access, however, I haven't worked alot on the
    > whole "Permission" peice of Access. I'm stuck, any help would be

    appreciated.
    >
    > Thanks.


    That database is corrupted. You can try the Repair option or try using
    JetComp (http://support.microsoft.com/default.aspx?scid=kb;en-us;273956) to
    do a Comapct and Repair. If all else fails, you'll have to create a new
    blank database and import all of the objects into it. That still may not
    work, though... If not, hopefully you have a backup of the database from
    before the problem started to revert to.
     
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