Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Inland Northwest(US)
    Posts
    19

    Exclamation Unanswered: Access 2000 Lockdown

    Ok, here's the situation. I just converted a program in Access97 to Access 2000. Now, I need to make sure no one can get in to tables and queries...etc. and change them. Could anyone tell me either how to do this or what and where I need to look up? I have a reference book but the index isn't helping a whole lot.
    I thank you in advance.
    Laeskia
    Last edited by Laeskia; 11-14-02 at 16:00.

  2. #2
    Join Date
    Jan 2002
    Location
    UK
    Posts
    67
    You can use the start up macros to make sure that the database can be opened in Edit mode only unless authorised users are using it:

    Eg:
    Environ$("User") gets the Windows LOGIN ID:

    Condition in the Macro Cud be:

    acSysCmd(6) = false and Ucase(Environ$("User")) <> "ROHIT"

    In the action add QUIT.


    HTH:

    ROHIT

  3. #3
    Join Date
    Oct 2002
    Location
    Inland Northwest(US)
    Posts
    19
    I am confused what you are suggesting that I do. The program has a password for users but what I don't want is users to be able to change tables and queries. Would I change something in my initial startup macro?
    Thanks,
    Laeskia
    Last edited by Laeskia; 11-14-02 at 16:09.

  4. #4
    Join Date
    Nov 2002
    Location
    Venezuela
    Posts
    5

    User-based permisions

    Originally posted by Laeskia
    I am confused what you are suggesting that I do. The program has a password for users but what I don't want is users to be able to change tables and queries. Would I change something in my initial startup macro?
    Thanks,
    Laeskia
    Hello Leskia,

    Have you tried to set Permisions via the "Security" option in tools? There is a Wizard that helps to secure a database.

    Blessings,

    Juan.

Posting Permissions

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