Re: Security in .adp?

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 09/15/04

  • Next message: '69 Camaro: "Re: Can I password a query or table in an Access db?" 
    Date: Tue, 14 Sep 2004 23:29:25 -0700

    Hi.

    Many Access developers create an MDE database file as the front end to
    prevent users from viewing the form designs, report designs, and modules.
    However, if you'd like at least _some_ of your users to view these objects,
    then SQL Server security won't be adequate. You would need to place all of
    your forms, reports, and modules in a separate MDB file, apply user-level
    security to the forms and reports, then link to the linked tables of the ADP
    file.

    HTH.

    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips.

    (Please remove ZERO_SPAM from my reply E-mail address, so that a message
    will be forwarded to me.)

    "Nexus" <anonymous@discussions.microsoft.com> wrote in message
    news:046201c49ac3$1cea16a0$a401280a@phx.gbl...
    > Thanks for your prompt reply :) I read up a little on
    > users and roles. But what they can offer is only security
    > on table level. What if i wan to prevent a particular
    > user from viewing a form in access?
    >
    > >-----Original Message-----
    > >Hi.
    > >
    > >> However, when i created the .adp file, i realise that
    > >> there the workgroup administrator function is not
    > >> available.
    > >
    > >When one converts an MDB database file to an ADP
    > database file, one gives up
    > >some of the functionality. Remember that built-in user-
    > level security?
    > >That's maintained by the Jet engine. You've thrown Jet
    > away by converting
    > >the database to use the MSDE, so the security available
    > within Access is
    > >gone.
    > >
    > >> What are the built in sercuity features for an
    > >> Access Project?
    > >
    > >The MSDE is a scaled-down version of SQL Server, but it
    > still has SQL
    > >Server's security features, like users and roles with
    > security permissions
    > >on database objects. You'll want to read SQL Server's
    > Books On Line (BOL)
    > >to find out how to use this properly. The "Inside SQL
    > Server" books are
    > >excellent reference books, too.
    > >
    > >> Is there any way i can set different
    > >> permission levels?
    > >
    > >Yes. Read the BOL. One can download it from this Web
    > page:
    > >
    > >http://www.microsoft.com/downloads/details.aspx?
    > FamilyID=a6f79cb1-a420-445f-8a4b-
    > bd77a7da194b&DisplayLang=en
    > >
    > >HTH.
    > >
    > >Gunny
    > >
    > >See http://www.QBuilt.com for all your database needs.
    > >See http://www.Access.QBuilt.com for Microsoft Access
    > tips.
    > >
    > >(Please remove ZERO_SPAM from my reply E-mail address,
    > so that a message
    > >will be forwarded to me.)
    > >
    > >
    > >"Nexus" <anonymous@discussions.microsoft.com> wrote in
    > message
    > >news:047901c49a05$97fe5cc0$a601280a@phx.gbl...
    > >> hi, currently i have a .mdb file running with a
    > workgroup
    > >> and different levels of users with different permission
    > >> level.
    > >>
    > >> I was thinking of using Access Project (.adp) instead
    > as
    > >> i read that it is better in a client/server
    > application.
    > >> However, when i created the .adp file, i realise that
    > >> there the workgroup administrator function is not
    > >> available. What are the built in sercuity features for
    > an
    > >> Access Project? Is there any way i can set different
    > >> permission levels?
    > >
    > >
    > >.
    > >

  • Next message: '69 Camaro: "Re: Can I password a query or table in an Access db?"

    Relevant Pages

    • Re: KB960089 Breaks Sharepoint Services Web Sites
      ... removes the "Network Services" user from the permissions list for the Windows ... go to that database file as well as it's associated log file. ... security and removed the Network Services user from both the Windows Internal ... Sql server service does not wants to run. ...
      (microsoft.public.windowsupdate)
    • RE: How do you use a Security Wizard Report?
      ... Check the Security Wizard Report to see ... Once found create a shortcut to open your database file as follows: ... Microsoft Access Support ...
      (microsoft.public.access.security)
    • Re: Bypass message?
      ... pay the $75 luxury tax even though you passed Go. ... If you set your macro security level to low, ... able) to change the security setting or digitally sign the database file, ...
      (microsoft.public.access.tablesdbdesign)
    • RE: How do you use a Security Wizard Report?
      ... >It sounds as if you are not using the correct WorkGroup ... >Once found create a shortcut to open your database file ... >Microsoft Security Bulletin MS03-026? ...
      (microsoft.public.access.security)
    • Re: Access 2003
      ... I then moved the database file that I could open up on the other domain to ... cannot open the reports, go into design view, etc. ... > longer exists on the network. ... If you can open it in design mode and then ...
      (microsoft.public.access.reports)