Results 1 to 7 of 7

Thread: form question

  1. #1
    Join Date
    Feb 2004
    Location
    Vermont
    Posts
    53

    Question Unanswered: form question

    How can I on a form keep track of everytime a person goes in and makes a change. For example I want the form to force the person to make a new record or at least keep track of every update.
    CAT :-D

  2. #2
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Do your users have to log in using a mdw?
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  3. #3
    Join Date
    Feb 2004
    Location
    Vermont
    Posts
    53

    form

    No they do not log in using a mdw. Everytime I have tried to set up security using the mdw I always mess it up and have had to replace my mdw, so until I have the time to totally sit down and figure out the security in access I do not really play with it.

    C

    Originally posted by JSThePatriot
    Do your users have to log in using a mdw?
    CAT :-D

  4. #4
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Well I dont know how you can track who changes a record without it. :-/ I track who changes a field in any one record using the CurrentUser() but I dont think that would work unless you have an MDW setup.

    Maybe I could help you set that up,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  5. #5
    Join Date
    Feb 2004
    Location
    Vermont
    Posts
    53
    Ok so how do I setup a MDW?

    Carley

    Originally posted by JSThePatriot
    Well I dont know how you can track who changes a record without it. :-/ I track who changes a field in any one record using the CurrentUser() but I dont think that would work unless you have an MDW setup.

    Maybe I could help you set that up,
    JS
    CAT :-D

  6. #6
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Originally posted by carley465
    Ok so how do I setup a MDW?

    Carley
    I am going to try to do this as step by step as possible.

    1. Open the database you want protected.

    2. Click on the Tools Menu

    3. Scroll down to the Security

    4. Click the User-Level Security Wizard...

    5. Click Next

    6. Type your Name and Company

    7. Make sure the selected option is "I want to create a shortcut...database."

    8. Click Next

    9. Click Next

    10. Select what groups of people will be accessing your database.

    11. Click Next

    12. Make sure the selected option is "No, the Users group should not have any permissions."

    13. Click Next

    14. Add U/N and P/W for each person with a unique PID

    15. Click Next

    16. Assign Users to different groups. (Your U/N I am assuming would need to be an admin and no one else).

    17. Click Next

    18. Select location for backup copy of unsecured database incase this corrupts.

    19. Click Finish


    If you have any questions please let me know.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  7. #7
    Join Date
    Feb 2004
    Location
    Vermont
    Posts
    53
    Can you have multiple U/N?

    Ultimately only one person should be able to go in and change settings, or possibly two, but all the different users that I have need to have different User levels. Can I do this?

    C

    Originally posted by JSThePatriot
    I am going to try to do this as step by step as possible.

    1. Open the database you want protected.

    2. Click on the Tools Menu

    3. Scroll down to the Security

    4. Click the User-Level Security Wizard...

    5. Click Next

    6. Type your Name and Company

    7. Make sure the selected option is "I want to create a shortcut...database."

    8. Click Next

    9. Click Next

    10. Select what groups of people will be accessing your database.

    11. Click Next

    12. Make sure the selected option is "No, the Users group should not have any permissions."

    13. Click Next

    14. Add U/N and P/W for each person with a unique PID

    15. Click Next

    16. Assign Users to different groups. (Your U/N I am assuming would need to be an admin and no one else).

    17. Click Next

    18. Select location for backup copy of unsecured database incase this corrupts.

    19. Click Finish


    If you have any questions please let me know.

    JS
    CAT :-D

Posting Permissions

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