Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    26

    Unanswered: Pls Help... Urgent

    Hi,

    Pls help me how to create different users for login into my Access application.

    I want to create 2 types of users

    1. Admin , 2. Normal User.

    I also want to restrict accessing of few modules for Normal User.
    I prefer to do this in the application level not in the database level.

    It is fairly simple concept. When I install the application at different systems, when I open the .mdb file, It should ask me to key-in username and password. The system should check the key-in user is Admin or Normal User.

    Pls help.

    Regards,
    Omav

  2. #2
    Join Date
    Mar 2002
    Posts
    32
    Go to tools....Security.

    Run the user-level security wizard.

    You should be able to set up an admin user and normal user.

    Publish the .mdw file created so that everyone has access.

    Using wrkgadm.exe on everyone's computer point them to your custom .mdw file.

Posting Permissions

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