Results 1 to 3 of 3

Limit User access in Runtime

  1. #1
    ggs
    ggs is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2011
    Location
    New Zealand
    Posts
    36

    Limit User access in Runtime

    Well I finished my Incident Report DB and I thought it covered all that we had planned for. Ha!!! Now the gnomes have said that's pretty good but can we have;
    There are 5 users covering 30 locations. What they want is the users to view and input only for their own location but also to have admin log in to view ALL for certain people. (all using runtime)
    I'm not sure I have the right concept of it all and there seems to be little on the internet about Runtime
    So my locations are stored in a query. I 'm thinking now I need a switchboard (I think i'll do my own) to be the default open form and now I need help.
    So a combo box maybe of locations including admin (or similar) and some code to run the query according to the input (oh yes and the password for each user. Am I on the right track?


    Funny how this Access thing sort of grows on you
    The more I know about Access the more I know the more I don't know

  2. #2
    apr pillai's Avatar
    apr pillai is offline Contributor
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    134

    Limit User access in Runtime

    If your database is implemented with Microsoft Access Security then take a look at the following link:

    Filtering data for different Users

  3. #3
    ggs
    ggs is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2011
    Location
    New Zealand
    Posts
    36

    multiple users

    I've had a quick read through and this sounds just what I want. When it is not 10:30pm I will give this a go thankyou

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

Similar Threads

  1. Replies: 1
    Last Post: 04-27-2011, 09:59 AM
  2. Replies: 0
    Last Post: 02-28-2011, 08:26 PM
  3. Access Runtime
    By SFC in forum Access
    Replies: 5
    Last Post: 02-15-2011, 09:33 AM
  4. Access runtime on CD?
    By Orabidoo in forum Access
    Replies: 1
    Last Post: 08-19-2009, 12:51 AM
  5. Replies: 0
    Last Post: 03-23-2009, 12:21 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
  •  
Tech Forums: Microsoft Office Forums