Results 1 to 13 of 13
  1. #1
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27

    Permissions


    Is it possible to make a form with seperate permissions? For instance, a form that lets users add a new entry, but does not allow them to view other entries or any of the tables?

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Yes it is. Save a copy of your database before creating permissions, you may get it wrong the first time and get locked out of your own forms.

    You can manually create same via the Security menu, I think that it's under Tools.

    Litwin, Getz et al's Access 2002 (or 2000) Developer's Handbook, Enterprise Edition has extensive code re same. I bought a used copy on Amazon for $10 + shipping.

    First create Security "Groups" then members of each "Group" then each new member (user) of that group requires one entry in the Groups as opposed to each object.

  3. #3
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27
    Awesome, after going to the options menu, I found the commands you speak of. However, I can't actually use any of them. They're grayed out. Is there a certain pre-requisite that needs to be filled before I can use them?

  4. #4
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    You probably don't have a full installation of Access, otherwise the menu item would not be grayed out.

  5. #5
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27
    I don't think that's the problem. I was sent another database from a coworker, and I could use the tools on that database, but not this one.

  6. #6
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Is there already an "MDW" extension file associated with your database. Otherwise, I don't have a clue.

  7. #7
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27
    To my knowledge there is no MDW file associated with it. Couldn't find one anyways, and I never made one. Even sent it to myself to try it on a different computer, didn't work.

  8. #8
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Create a new database with one table and try to create permissions.

    If you can't, the problem is with your Access installation. If you can, it's a problem with your database.

  9. #9
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27
    Awesome. Go workplace team. You'd laugh if you knew who I worked for.

  10. #10
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    You're probably at JPL with responsibility for controlling the Phoenix Mars Lander.

    What did you do or stumble into?

  11. #11
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27
    New database, no permissions functions. The only db I can manage to have the ability to use those functions is the one I was sent by a coworker. Well, might as well see if I can use their base, copy over all the tables, save it under a new name and still be able to use them.

    BTW, not controlling anything as expensive as the Phoenix Mars Lander, but the company idea isn't too far off.

    Thanks for your help.

  12. #12
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Smart people don't know all there answers. As Part Hartman of Access World Forums says, "Bridge players know all the tricks."

    If you're at JSC, I'm literally a rock's throw away; worked on Apollo and Skylab programs, then got into the oil & gas business, then back to database programming.

  13. #13
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27
    That's pretty awesome. Import wizard worked like a charm, got permissions usage and all my data.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access permissions
    By paulbrog in forum Access
    Replies: 1
    Last Post: 05-05-2009, 11:14 AM
  2. Replies: 0
    Last Post: 03-09-2009, 03:09 PM
  3. Replies: 0
    Last Post: 02-15-2007, 09:10 AM
  4. Permissions instruction
    By admaldo in forum Security
    Replies: 0
    Last Post: 05-11-2006, 01:49 PM
  5. Problems with run permissions on a query
    By admaldo in forum Queries
    Replies: 0
    Last Post: 05-09-2006, 09:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums