Results 1 to 4 of 4

Thread: added security

  1. #1
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011

    Unanswered: added security

    I have a little DB app that I'm working on securing. Currently, both the BE and FE are setup with the "Bypass key" disabled and "Ctrl-Break" disabled.

    The FE has a slash screen, etc. and the BE checks to see if the user is in the IT Group - if not, they get booted.

    This works ok for when a file is opened directly. But, a slightly more savy user can simply link to the BE and gain uncontrolled access to the data tables.
    Is there a way to set the BE to disallow new links?

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Posts
    81
    If a table in the BE has the Hidden attribute set it will not show in the Link Table window from another database. Good enough?

    Bjorn

  3. #3
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    Most excellent - that closes that little loop.

    Thanks!

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    there is another way you might want to consider.

    a little-documented feature of access is that tables with names beginning
    usys
    e.g. usysThis, usysThat, usysMyTable
    are hidden without the need to set the hidden flag!

    have a look at this which may or may not worry you if you use hidden tables.

    izy
    currently using SS 2008R2

Posting Permissions

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