Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security in Access 2007 (Access 2007)

    Hi all,
    From what I can tell one cannot secure a 2007 Access database in the same ways one would in 2003 Access. Like Creating your own custom menubars, using code to disable the bypass key, changing startup options so the main db window does not appear, and only allowing access to forms one wishes to supply for data entry. It looks to me that the Navigation bar on the left can be manipulated, but that is by anyone, so even if I turn something off, they can turn it right back on, and when they have full access to everything this is totally not going to be the same. Other then passwording to keep any unauthorized individuals out I don't see a whole lot to make a db secure. Is it just me? Can anyone point me to a good book maybe on Access Security features? Have any advice here?

    Appreciate the feedback
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Security in Access 2007 (Access 2007)

    Custom toolbars etc. are only displayed if you (1) don't allow built-in toolbars and (2) specify a custom menu bar in the startup options.

    Some links that may be useful (although they're not only about the subject you asked about):
    Migration considerations for Access 2007
    Transitioning Your Existing Access Applications to Access 2007
    Security Considerations and Guidance for Access 2007

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security in Access 2007 (Access 2007)

    I didn't see the normal startup options in 2007 as in 2003. In Startup options in 2003 it was plain as day. Will look around some more and look through your helpful articles. Thanks Hans,
    Imagine I'll be back on this topic...
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Security in Access 2007 (Access 2007)

    The startup options in Access 2007 are found under Office button > Access Options > Current Database.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security in Access 2007 (Access 2007)

    Got it. Thanks, I see there is an option to turn off default ribbon and Shortcut menu there as well, so Access must allow you to create new customized ones to replace them in a secure database (like we did in 2003). I checked out the customize box and saw how to add to the Quick toolbar, am I correct in assuming that you can create your custom menus there as well? Or is it just a matter of unchecking what you don't want them to access on each item listed in there....thats a lot of stuff to uncheck. I saw nothing about creating pop-up menus that I used to create when someone would right-click on something in the db...we used to be able to control what was on that as well.
    Thanks for all the help...
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Security in Access 2007 (Access 2007)

    The option to customize toolbars and right-click menus in the interface has been taken away in Access 2007 - you are supposed to use the ribbon now. But you can still manipulate toolbars, right-click menus etc. in VBA code, just as in earlier versions.

    If you'd like to learn about customizing the ribbon, see Customizing the Office Fluent User Interface in Access 2007.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security in Access 2007 (Access 2007)

    Thanks Hans, will read...
    I have created a toolbar (custom) and a menubar (custom), yet there is no drag and drop feature as there used to be to put things into those new custom items, so still have a ways to go...empty toolbar and menubar right now until I figure out how to populate it...Will read what you've given me, and maybe the answer is there.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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