Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    Freeport, New York, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security again (2000, XP (in general))

    I am developing a new app where traders enter trades but they may see only their OWN trades. All trades are stored in the trades table and all tables (data) are stored in a linked MDB on a server. All the other users can see all trades.

    I can prevent traders from opening other people's trades in the app itself (hide the database, make the app an executable, code so the person logging on can see only his own trades--these people will be in the same user group so Access security doesn't help much), but they have the full version of Access on their computers so in theory they could open the tables directly.

    I THINK that the server files can be protected (server software, nothing to do with Access) so that the data MDB can be opened only by the app itself or by an administrator. Right?

    Anyway, any ideas?
    Thanks,
    Mere

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Security again (2000, XP (in general))

    No, users need full rights to the folder the .mdb resides in and to the .mdb file, otherwise the database can be opened by only one user at a time.

    It might be possible to deny the users rights in the tables, and only give them rights to use queries that select the appropriate records. Others will probably come up with suggestions about this.

    Otherwise, you'd have to move the data to SQLServer; it has more extensive security than Access.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security again (2000, XP (in general))

    The Security FAQ has some details on restricting data by Rows/columns.

    HTH

    Peter

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Security again (2000, XP (in general))

    There is also important information about how to establish security for linked tables in a back-end database - it's in section 13 of that document.
    Wendell

Posting Permissions

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