Results 1 to 6 of 6
  1. #1
    Join Date
    May 2002
    Location
    Chicago
    Posts
    22

    Red face Unanswered: Access 2000 security

    Before I start implementing security ( I am really new to this) on our Terminal server/Lan and Wan/ Access 2000/ ODBC datasources environment, can anyone tell me what I should really know? What are the issues, pros and cons, etc?

    Any help greately appreciated!!!

  2. #2
    Join Date
    May 2002
    Location
    Chicago
    Posts
    22
    Sorry I posted this so many times, had no idea that it would be here!!!

  3. #3
    Join Date
    May 2002
    Location
    Long Island , New York
    Posts
    3
    Access workgroup based security seems weak, and trouble to admin on a LAN; I'm in the middle of working on this myself; best thing I've found so far is ability to turn off the table/query/report window with :
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide

    and turn off "Allow full menus" in the Access startup

  4. #4
    Join Date
    May 2002
    Location
    Chicago
    Posts
    22
    Thanks for your reply!

    I used the feture of hiding the database, but without using code. It does the same thing, and I also removed toolbars.

    I am not looking to implement a tight security, our main problem is that running the updates on tables using ODBC (by multiple users) causes the USQL service to stop. My idea was to give Access 'users', so I could set up database to allow a single user at the time. This may sound really backward, but the ODBC errors are worse on our production, and we don't seem to find any better way...

  5. #5
    Join Date
    Jan 2002
    Location
    UK
    Posts
    67
    Try to open the database exclusively for each user by opening the database from the command line.


    ie use /excl at the end of the command line to open the database.
    The better part will be to open using an execuatble commandline script and in case the user is unable ot open the database in the exclusive mode. Stop him from opening the database.

  6. #6
    Join Date
    May 2002
    Location
    Chicago
    Posts
    22
    Thanks, but couldn't you do the same by going to Tools>Options>Advanced>Default Open Mode and checking the "Exlusive"? Is there a problem with ODBC data sources- which have to be shared?

Posting Permissions

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