Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Lock the Object Sections

    Hi

    In MS Access:

    Objects:
    Tables
    Queries
    Forms
    Reports
    Pages
    Macros
    Modules

    Groups:
    ...

    I want to lock the Objects section, because I made the Groups in the groups section. How can I lock the objects section.

    Please let me know, thanks a lot.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What are you talking about? Are you giving users access to the raw database? tsk tsk...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2005
    Posts
    313
    Yes, someone will work in the database, so I want to lock the Objects section.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You know, you may be better off using more conventional methods... say creating an interface for your users to access only the objects you want and hiding the raw database?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Sep 2005
    Posts
    313
    what's that means?

    "interface",

    does it means that create another database,and then link the tables, queries, etc. to the new database?

  6. #6
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by accessman2
    what's that means?

    "interface",

    does it means that create another database,and then link the tables, queries, etc. to the new database?
    Hi accessman2,

    Interface meaning what the users see when they work in the database, i.e. Forms, Reports, etc. It is real bad VooDoo to allow all users access to your raw data(Tables). If they tinker around not knowing what they are doing, they can wipe out data. OR you can split the database with the Database Splitter and create FrontEnd/BackEnd scenario. But be wise, DO NOT ALLOW ACCESS TO RAW DATA BY EVERYONE.

    have a nice one,
    BUD

  7. #7
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    I a gree with bud

    What the user can't see they can't **** delete
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •