Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Application Security using Access Project (adp) (Access XP)

    Using a secured Access database, it is possible to restrict access to certain features of the application using a secure workgroup, setting up users and groups and then programmatically testing who is logged in and then assigning permissions based on that users group membership.

    My problem is that I need to do is the same thing to an Access Project application, but an Access project cannot use the Jet database workgroup features. So far I haven't been able to find any real information on how to secure an Access project application. If anyone has any examples, knows of any good books/magazines on this subject, I would really appreciate it, Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Application Security using Access Project (adp) (Access XP)

    An Access project is a front end for SQL Server. You need to look into the SQL Server security features, groups and roles.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jul 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Application Security using Access Project (adp) (Access XP)

    I understand that the data security is done through the SQL Server, what I am trying to figure out is how to use the "login" information in the Access front-end to restrict the users ability to open forms, execute command buttons, etc.

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

    Re: Application Security using Access Project (adp) (Access XP)

    Unfortunately, as you have already discovered, you can't apply user security to an ADP. About the only choice is to role your own security system, making forms and menu items available to some users and not to others. SQL Server security will let you do many things, but it isn't able to prevent some users from seeing a form tab or other control, or letting some users do data entry on a form and others not.

    We often choose to use an ODBC linked SQL Server for that reason among others, but if you're well down the ADP route, it's a fair bit of work to reverse course. Hope this clarifies things a bit.
    Wendell

  5. #5
    New Lounger
    Join Date
    Jul 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Application Security using Access Project (adp) (Access XP)

    Well, that is what I was afraid of, I briefly thought ADOX might provide a solution, but if it does I cannot figure it out. Thanks everyone for your help, I do appreciate it!

Posting Permissions

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