Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to use Security Wizard (2002)

    I'm trying to secure access to the macros in my app.
    I get several errors i.e. exculsive use, groups, users etc. Can't get it to work.
    Frank

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

    Re: How to use Security Wizard (2002)

    Frank, that isn't very specific. Are you getting those errors from the Security Wizard? Try giving a specific error and including the entire error message.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to use Security Wizard (2002)

    Hi Charlotte,
    Sorry about jumping threads.
    I get things like I'm not the exclusive user and can't open any object etc. but that is not the point please don't grill me on these points. I'd like a walk-through of the steps to secure the macros and what you would recommend so my client can't get to my code behind the forms and my macros. I know this is primitive programing but I'm not that good at VBA yet.
    Just a little walk-through, I don't know how to get more specific and I feel this can be understood or figured out without any more elaboration.
    Your help and the loungers who have helped is stellar and heartfelt.
    It's been a rough day.
    Frank

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to use Security Wizard (2002)

    Hi Frank. Securing a database is a complex subject. What you are asking is almost like saying "How do I design a form?" or even "How do I use MS Access." When you look at the material in the help file you will understand why.

    I would suggest you start in the help file by typing into the Help Answer Wizard "secure a database" then in the lower left pane select "secure a Microsoft Access Database" then, in the right hand pane select "Learn about protecting a Microsoft Access database" This help item should give you a good leg-up. Then you can come back with more specific questions if you still have problems. (Based on A2K)

    BTW isn't the help system easy to find your way around in! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    David Grugeon
    Brisbane Australia

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to use Security Wizard (2002)

    Well thanks David.
    Maybe I'm naive, but I just followed the wizard, deselected macros and got different errors, "I'm not the exclusive user and I could't open any objects,
    I will read the help file.
    Frank

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to use Security Wizard (2002)

    There are a number of things in Access that require Exclusive use of the database - such as modifying the design or structure of a multi-user database and making security changes.

    This is very simple to do:
    1) Launch Access (you have 2002, right?)
    2) Get to the File | Open... Dialog (without opening a database)
    3) Navigate to your selected database
    4) Click ONCE on your database to select
    5) Click the little Down-arrow to the RIGHT of the Open button (located at the bottom-right side of the dialog)
    6) Select Open Exclusive from the menu - VOILA! You've just opened your database Exclusively! This means that no other users can open it while you have it opend Exclusively.

    Now you can run the Security wizard successfuly (hopefully).

  7. #7
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to use Security Wizard (2002)

    HI Mike,
    Thanks for getting back to me.
    I got it in exclusive mode. In fact it was set in exclusive mode previously. I guess I set it previously. I have it networked to another computer so I guess I have to set it back shared mode for the other computer to access the data?
    I'm kind of confused on the options in the security wizard. User, groups, group users etc.
    What would my client be?
    Does she set a password to get in?
    I don't want her to be able to open the macros.
    Thanks for all of your previous help.
    A walk-through would be highly appreciated. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Frank

  8. #8
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to use Security Wizard (2002)

    Hi Fred,

    Have you taken a second to look at the helpfile that was suggested in <post#=183331>post 183331</post#>?

    That's about the best walkthrough you're going to get! <img src=/S/rtfm.gif border=0 alt=rtfm width=24 height=23>

    Also, a quick search for "security faq" turned up a link to Microsoft's Security FAQ file (in <post#=129216>post 129216</post#>): http://support.microsoft.com/support/acces...tent/secfaq.asp

    Hope this helps

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

    Re: How to use Security Wizard (2002)

    <font color=blue><<I'm kind of confused on the options in the security wizard. User, groups, group users etc.
    What would my client be?
    Does she set a password to get in?
    I don't want her to be able to open the macros.
    Thanks for all of your previous help.
    A walk-through would be highly appreciated. >></font color=blue>

    I don't think we can make this much clearer for you - books typically devote at least a chapter to the subject of security. Really good ones may devote 2 or 3 chapters and a hundred or more pages to it. The info in the help files is the best brief (and it isn't really brief) introduction to security, and it provides a "walk through" of how to properly use the security wizard. The lounge simply isn't intended as a place for lengthy tutorials - it works best at solving specific, well described problems.
    Wendell

  10. #10
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to use Security Wizard (2002)

    Thanks Wendell,
    Didn't know I'd have to bone up on that much data.
    I will.
    I thought I was asking for a quick and simple answer.
    I'll keep with the program.
    Best,
    Frank

Posting Permissions

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