Results 1 to 7 of 7
  1. #1
    Join Date
    May 2004
    Posts
    38

    Unanswered: Limiting table access

    Hi,

    I just know the basics of Access, but not how to VB program it.
    I want to set up a table so that users can read and alter data
    within it, BUT they can not actually open and look at the table.
    I've looked into the user rights, and when I just click "read data"
    it automatically permits read design as well (which I assume is
    what gives access for opening the table).

    Is there a way to do this ? Set up a table so users can read and
    change data in it, but can not actually open and look at the table ?

    Thanks.

  2. #2
    Join Date
    Aug 2006
    Posts
    559
    Why not create a form where the user can enter in data and link the table to it? Like have the fields of the table display on that form? That's very basic. The user won't have access to it then. You can also use ULS (user level security) but also, from what I've seen, split the database into a front-end and back-end on a network share and the user will (more than likely) not be the wiser.


    **Also disable the datasheet view, from the form, that''ll stop the user from being able to see the table / records.

    Let use know if that's what you're looking for. If it's not, I'm sure we can continue.

  3. #3
    Join Date
    May 2004
    Posts
    38
    Quote Originally Posted by Grafixx01
    Why not create a form where the user can enter in data and link the table to it? Like have the fields of the table display on that form? That's very basic. The user won't have access to it then. You can also use ULS (user level security) but also, from what I've seen, split the database into a front-end and back-end on a network share and the user will (more than likely) not be the wiser.


    **Also disable the datasheet view, from the form, that''ll stop the user from being able to see the table / records.

    Let use know if that's what you're looking for. If it's not, I'm sure we can continue.
    Thanks, but that's not exactly what I'm looking for.

    What I meant was, disabling datasheet view for a TABLE, not a form.

    I want the users to be able to read/edit data in a form that accesses the table, BUT, I don't want them to be able to see the table itself.

    Another words, the users edit data in a form. I don't want them to be able to go into the lists of the tables, open the table, and see the datasheet for that table. I don't mind if they see the datasheet for the form, I just don't want them looking at the datasheet for the table the form's referring to.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    What I do is hide the tables by right clicking then and click hide

    then in the tool ->option ->view make shour the hidden object is click off
    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.

  5. #5
    Join Date
    May 2004
    Posts
    38
    Quote Originally Posted by myle
    What I do is hide the tables by right clicking then and click hide

    then in the tool ->option ->view make shour the hidden object is click off
    Thanks for the idea, but I don't think that would be secure enough.
    Someone could simply turn the hidden objects on.

  6. #6
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Ture but

    what I also do is put =1 in the menu bar

    try it and see what happen

    what Use can not see they can not delete

    also if the Data is link to database then That is not a problem cause if the User Delete the Table they are only deleting the link not the data

    I have had User try is delete the tables (links)
    all i did was reported to there manager problem was fix
    peson not work in dataentry again.
    Last edited by myle; 06-03-07 at 19:09.
    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.

  7. #7
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by Pathology
    Thanks, but that's not exactly what I'm looking for.

    What I meant was, disabling datasheet view for a TABLE, not a form.

    I want the users to be able to read/edit data in a form that accesses the table, BUT, I don't want them to be able to see the table itself.

    Another words, the users edit data in a form. I don't want them to be able to go into the lists of the tables, open the table, and see the datasheet for that table. I don't mind if they see the datasheet for the form, I just don't want them looking at the datasheet for the table the form's referring to.

    Splitting the db and making it reside on a network share links the tables from the back-end to the front-end. You'll see this by an "-->" (arrow) on the list of tables. If you try to open the table, it'll let you but will give you a warning message saying that it's linked and that it has some properties that cannot be modified.

    On a side note, there are many other things that you can do to eliminate the possibility of your users being able to view the tables. Hide the MS Access Main Window, lock it so that only the db forms are viewable. One database that I made a while back, you had to open the db, logging into it, then the only way that you can edit it was to open it again while it was open because you did not have the ability to right-out see the forms, tables, queries, and other aspects of Access.

    You can do this. Or create a startup event that minimizes / hides the MS Access main window (where like file, edit, tools) are viewable and only opens the switchboard that you create for the database. You can then have this only bypassed by holding the shift key, or even creating a "password-protected" shift-bypass key where the user will have to know the password you assign to it.

    Better?

Posting Permissions

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