Results 1 to 5 of 5

Thread: database login

  1. #1
    Join Date
    Jan 2004
    Posts
    11

    Unanswered: database login

    hi, im making a dispatch db for a volunteer ambulance corp

    I have 2 users id's in access, 1 is admin and the second is dispatcher.

    I want the admin to do anything

    I want the dispatcher to just enter new entries, not delete anything.
    and i was able to figure it out...but...

    Lets say someone walks in and turns on the computer and starts the shift of the day, is there a way when they open the database that the default user will be "dispatcher" unless they enter a password to get in the admin?

    Thanks for any help

  2. #2
    Join Date
    Sep 2003
    Location
    Caldes de Malavella, Spain
    Posts
    244

    Re: database login

    No. Each person will have to log into the database to receive their permissions, and there is no default user. The only way you could do this would be to code it yourself rather than use Access' built-in security.


    Originally posted by y2kmental
    hi, im making a dispatch db for a volunteer ambulance corp

    I have 2 users id's in access, 1 is admin and the second is dispatcher.

    I want the admin to do anything

    I want the dispatcher to just enter new entries, not delete anything.
    and i was able to figure it out...but...

    Lets say someone walks in and turns on the computer and starts the shift of the day, is there a way when they open the database that the default user will be "dispatcher" unless they enter a password to get in the admin?

    Thanks for any help
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy
    http://www.elmhurstsolutions.com

  3. #3
    Join Date
    Jan 2004
    Posts
    11
    how would they login?

  4. #4
    Join Date
    Sep 2003
    Location
    Caldes de Malavella, Spain
    Posts
    244
    In Access, you can turn on the inbuilt security so that each user has to log in with a user name and password. Before you do this, you create users and groups, assign permissions to groups and then assign users to those groups. Search Access Help on "Security".

    However, Access' own security can be difficult to set up properly for the uninitiated. Also, it is a bit limited in what it can do.

    The alternative is to create your own security system, which will give you far more flexibility and allow you to control what users can do with a higher degree of precision and control. To get you started, there is an article about this on our website (see link below).

    I hope this helps and good luck!!


    Originally posted by y2kmental
    how would they login?
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy
    http://www.elmhurstsolutions.com

  5. #5
    Join Date
    Jan 2004
    Posts
    11
    this looks like a great idea but it isnt working for me

Posting Permissions

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