Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Password Protect a Report (2000)

    Hi,

    I have a report that should only be viewed by a few individuals. Is there a way to password protect the report so that when it opens the user is prompted to insert the password. The report would only open if the correct password is supplied.

    Thanks!

    Leesha

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protect a Report (2000)

    You should use User Security. If the report may not been visible to certain users then some tables or/and queries would also remain not visible. The only way to protect this is by User Security.
    Francois

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Password Protect a Report (2000)

    I was hoping there was code that would prompt for the user to insert their password ............on the specific report so I wouldn't run into issues with the user security. It just always seems to create a nightmare when I do that as I'm not on site to add new users etc. and this isn't a group who can do this on its own.

    Leesha

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protect a Report (2000)

    In the On Open event of the report, you could use something like :
    <pre>Dim MyAnswer As String
    MyAnswer = InputBox("Enter Password")
    If MyAnswer <> "MyPassword" Then
    MsgBox "Password not correct"
    Cancel = True
    End If</pre>

    And at least provide the database as a MDE file to avoid the user going into the code to see the password
    Francois

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Password Protect a Report (2000)

    Thanks! This will do exactly what I'm looking to do. I doubt this group could figure out how to get into the code, but one never knows. The MDE is a great idea!

    Leesha

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protect a Report (2000)

    Don't underestimate a user. All they shouldn't do or you think they can't do, well they will do it <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    Francois

  7. #7
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Password Protect a Report (2000)

    Don't I know it!!! And................that includes me!!!! <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

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

    Re: Password Protect a Report (2000)

    We deal with that by having several pre-built user logins that can be used by more than one person. We distribute a workgroup file with our applications, so the login and password is already there when our applications are installed.
    Charlotte

Posting Permissions

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