Welcome to SPN

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

Sign Up Now!

Locking Queries, Forms and Reports

Discussion in 'Information Technology' started by SailFL, Nov 18, 2005.

  1. SailFL

    SailFL
    Expand Collapse
    Guest

    I have created a number of Forms, Reports and Queries for my client. Is
    there a way of locking these items so that normal users can not modify them?
    I don't want to lock the database just the above mentioned.

    Thanks
    --
    SailFL
     
  2. Loading...

    Similar Threads Forum Date
    Unlocking the House of the Almighty Gurmat Vichaar May 5, 2009
    Sikh News Calif. county wrong in blocking Sikh temple: court (Reuters via Yahoo! News) Breaking News Aug 5, 2006
    Importance of Hukamnama - Some Queries Sikh Sikhi Sikhism Jun 14, 2009
    Queries History of Sikhism Oct 26, 2006

  3. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

    Convert the Front End to an MDE. If the user site actually needs the
    MDB, ship it to the manager or administrator concerned. If ANYONE
    gets a copy of the MDB then the fox is loose in the henhouse. Where I
    have ongoing work with a client I make all changes on a copy of the
    MDB that has never left my custody. I absolutely, positively and very
    sincerely refuse to be responsible for code that may have been altered
    by someone else since I last had it.

    HTH
    --
    -Larry-
    --

    "SailFL" <SailFL@discussions.microsoft.com> wrote in message
    news:11E32443-0720-4F93-A5C2-2C456DB74681@microsoft.com...
    > I have created a number of Forms, Reports and Queries for my client.

    Is
    > there a way of locking these items so that normal users can not

    modify them?
    > I don't want to lock the database just the above mentioned.
    >
    > Thanks
    > --
    > SailFL
     
  4. SailFL

    SailFL
    Expand Collapse
    Guest

    Larry, that is good advise but I am one of those kind of guys that doesn't
    like to quess. I suppose that means no there is not a way of locking these
    things.

    Thanks
    --
    SailFL


    "Larry Daugherty" wrote:

    > Convert the Front End to an MDE. If the user site actually needs the
    > MDB, ship it to the manager or administrator concerned. If ANYONE
    > gets a copy of the MDB then the fox is loose in the henhouse. Where I
    > have ongoing work with a client I make all changes on a copy of the
    > MDB that has never left my custody. I absolutely, positively and very
    > sincerely refuse to be responsible for code that may have been altered
    > by someone else since I last had it.
    >
    > HTH
    > --
    > -Larry-
    > --
    >
    > "SailFL" <SailFL@discussions.microsoft.com> wrote in message
    > news:11E32443-0720-4F93-A5C2-2C456DB74681@microsoft.com...
    > > I have created a number of Forms, Reports and Queries for my client.

    > Is
    > > there a way of locking these items so that normal users can not

    > modify them?
    > > I don't want to lock the database just the above mentioned.
    > >
    > > Thanks
    > > --
    > > SailFL

    >
    >
    >
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "SailFL" wrote

    > Larry, that is good advise but I am one of those kind of guys that

    doesn't
    > like to quess. I suppose that means no there is not a way of locking

    these
    > things.


    You can get the Access Security FAQ and apply security -- you can grant
    permissions to a group, and assign all users to that group. Don't give the
    users any design view permissions on the objects you want to protect. I
    suppose you could remove Admin from the Admins group, and everyone could
    continue to just open and use... there's nothing that says the default login
    name "Admin" actually has to have any design view permissions.

    Larry Linson
    Microsoft Access MVP
     
  6. SailFL

    SailFL
    Expand Collapse
    Guest

    I am surprised and disappointed that there is not a way to lock individual
    queries, forms and reports from being modified with out requiring the whole
    database from coming under a password protection. You can protect individual
    documents or spreadsheets. A small business does not want to use passwords
    but there you don't want your reports, forms or queries changed.

    Thanks
    --
    SailFL


    "Larry Linson" wrote:

    > "SailFL" wrote
    >
    > > Larry, that is good advise but I am one of those kind of guys that

    > doesn't
    > > like to quess. I suppose that means no there is not a way of locking

    > these
    > > things.

    >
    > You can get the Access Security FAQ and apply security -- you can grant
    > permissions to a group, and assign all users to that group. Don't give the
    > users any design view permissions on the objects you want to protect. I
    > suppose you could remove Admin from the Admins group, and everyone could
    > continue to just open and use... there's nothing that says the default login
    > name "Admin" actually has to have any design view permissions.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
    >
     

Share This Page