Results 1 to 3 of 3
  1. #1
    EliOklesh is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    7

    Custom User Group queries

    I'm new to using User Groups/Permissions in Access, I'm feeling through it to figure out how it works.

    Is there to create a query that will show a particular user only his or her entries into a database? The project is a shared application where numerous users will submit requests to an Admin. There will be an option for Users to edit their requests, and I want each user to only be able to see their own requests.

    Is this possible?

    Thanks!


    eo

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    Yes, it is possible. But, you must be using a database of Access2003 or earlier versions.

    Check the following example, filtering data for the logged in User:

    http://www.msaccesstips.com/2008/03/...fferent-users/

    The database must be implemented with Microsoft Access Security, that works with only Access2003 or earlier version databases. But you can open earlier version (2000, 2002-2003) databases implemented with Security and work normaly in Access2007 too.

    http://www.msaccesstips.com/2006/11/...cess-security/
    http://msaccesstips.com/2011/08/runn...in-access2007/

  3. #3
    EliOklesh is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    7
    Excellent, it worked like a charm, thanks!

    Yeah, I'm using 2007 but it is rare that I ever work in the .accdb format. It's .mdb for me, all the way.

    Thanks for the help!

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

Similar Threads

  1. Replies: 7
    Last Post: 02-22-2013, 04:57 PM
  2. Macro stops working for 'USER' group
    By EliOklesh in forum Security
    Replies: 1
    Last Post: 10-28-2011, 07:54 PM
  3. Replies: 1
    Last Post: 06-20-2011, 03:56 PM
  4. Change a User's Group
    By Ted C in forum Security
    Replies: 1
    Last Post: 07-16-2010, 09:20 AM
  5. User and Group Permissions
    By sdondeti in forum Security
    Replies: 1
    Last Post: 02-01-2010, 05:47 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