Welcome to SPN

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

Sign Up Now!

Protecting entire tables in Access

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

  1. Rob

    Rob
    Expand Collapse
    Guest

    Hello,
    Is there a way to protect entire tables to prevent data changes? I have
    tables for annual budget detail. Once the budget is complete I do not want to
    allow any changes, but want to allow other users to build and run queries.
    Thanks for your help.
     
  2. Loading...

    Similar Threads Forum Date
    SALDEF Protecting Sikh American Students Sikh Organisations Mar 17, 2011
    United Sikhs Protecting the Identity of Minorities: A Sikh's Duty Sikh Organisations Jan 22, 2011
    United Sikhs 2010 Global Sikh Civil and Human Rights Conference : Role of Women in Protecting Sikh Identity Sikh Organisations Dec 30, 2010
    United Sikhs Protecting Our Right to Kakaars: UNITED SIKHS Works Across the Country to Address Civil Rights Viola Sikh Organisations Oct 18, 2010
    SALDEF Protecting the Sikh ID in Georgia (SALDEV) Sikh Organisations Aug 20, 2010

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Rob wrote:
    > Hello,
    > Is there a way to protect entire tables to prevent data changes? I
    > have tables for annual budget detail. Once the budget is complete I
    > do not want to allow any changes, but want to allow other users to
    > build and run queries. Thanks for your help.


    The database should be secured and split.

    You split the database by keeping the tables in one copy on the server
    on the LAN and each user gets their own copy of the queries, reports and
    forms. They will be able to make all the new queries forms etc they like.

    You secure the database using Access Security to keep them from making
    data 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
     
  4. Rob

    Rob
    Expand Collapse
    Guest

    Thank you. I should have mentioned I am not concerned with security issues,
    just inadvertant mistakes by 1 or 2 users. Is there another way of
    accomplishing this without splitting the database? Can I make a few of the
    tables "read only"?
    Rob

    "Joseph Meehan" wrote:

    > Rob wrote:
    > > Hello,
    > > Is there a way to protect entire tables to prevent data changes? I
    > > have tables for annual budget detail. Once the budget is complete I
    > > do not want to allow any changes, but want to allow other users to
    > > build and run queries. Thanks for your help.

    >
    > The database should be secured and split.
    >
    > You split the database by keeping the tables in one copy on the server
    > on the LAN and each user gets their own copy of the queries, reports and
    > forms. They will be able to make all the new queries forms etc they like.
    >
    > You secure the database using Access Security to keep them from making
    > data 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
    >
    >
    >
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Rob wrote:
    > Thank you. I should have mentioned I am not concerned with security
    > issues, just inadvertant mistakes by 1 or 2 users. Is there another
    > way of accomplishing this without splitting the database? Can I make
    > a few of the tables "read only"?
    > Rob
    >
    > "Joseph Meehan" wrote:
    >


    You can accomplish the job without splitting the database, but it is far
    better to do so. Sharing a database without splitting is asking for
    performance, corruption and other problems.

    I suggested the security tools because they can do what you want. The
    use of security also provide opportunities for control that you want.

    Splitting the database and security are two separate issue and you can
    do either without the other.

    --
    Joseph Meehan

    Dia duit
     
  6. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    if you used Access Data Projects; this would be QUITE easy to do.

    don't you wish your database had features like me?

    dont you?
    dont you?


    Joseph Meehan wrote:
    > Rob wrote:
    > > Thank you. I should have mentioned I am not concerned with security
    > > issues, just inadvertant mistakes by 1 or 2 users. Is there another
    > > way of accomplishing this without splitting the database? Can I make
    > > a few of the tables "read only"?
    > > Rob
    > >
    > > "Joseph Meehan" wrote:
    > >

    >
    > You can accomplish the job without splitting the database, but it is far
    > better to do so. Sharing a database without splitting is asking for
    > performance, corruption and other problems.
    >
    > I suggested the security tools because they can do what you want. The
    > use of security also provide opportunities for control that you want.
    >
    > Splitting the database and security are two separate issue and you can
    > do either without the other.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
     

Share This Page