Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security Warning Message (2003 (11.6566.8107))

    Edited by HansV to replace Word doc with a picture of the message box it contained.

    I have a database that several users can access to drop in data. However, they get the attached message when they attempt to open the database. However, I don't get this message. Please help me figure out why they get this message and I don't.
    Attached Images Attached Images
    • File Type: png x.png (7.5 KB, 1 views)

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

    Re: Security Warning Message (2003 (11.6566.8107))

    See Frequently asked questions about Access security warnings, in particular points 20 through 23.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Security Warning Message (2003 (11.6566.8107))

    Hi Hans, what is your recommendation for this problem? I have had my macro security set to low for quite a while now. I also send databases i develop to Clients, should i set one of the following?

    Would you set Sandbox mode to a level of zero?

    Would you set a Certificate?

    Or is there another option?

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

    Re: Security Warning Message (2003 (11.6566.8107))

    For professional work, I'd buy a certificate and sign all my code with it. Clients only have to confirm that they trust the certificate once.

    Setting macro security to Low and Sandbox mode to 0 is fine for yourself, or if you create a database for an acqaintance, but you cannot expect commercial clients to have these settings.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Security Warning Message (2003 (11.6566.8107))

    Where do i buy a certifcate and how do i apply it to a database?

    I have just noticed when i set the Macro security to a certain value that it then applies to all databases on my pc.

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

    Re: Security Warning Message (2003 (11.6566.8107))

    See the (slightly outdated but mostly relevant) Signing a VBA Project

    Well-known companies that give out digital certificates are Thawte and VeriSign

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

    Re: Security Warning Message (2003 (11.6566.8107))

    Macro security is an application-level setting, not a database-level setting. It is not stored in the database (but in the HKEY_CURRENT_USER section of the Windows registry).

    So even if you set macro security to Low, this has no bearing at all on the macro security level of your clients.

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Security Warning Message (2003 (11.6566.8107))

    Thanks Hans.
    That makes sense, it had to be outside a database.

    I think i will keep my macro security level low and when i send it to clients i will send the certificate as well, or whatever i have to do.
    I will read the links in your previous email to work this out.

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Security Warning Message (2003 (11.6566.8107))

    The VeriSign certificates are very expensive, and so are the other one you mentioned.

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

    Re: Security Warning Message (2003 (11.6566.8107))

    "Real" digital certificates are certainly not cheap. If you have only a small number of clients, it may not be worth while to get one.

  11. #11
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Security Warning Message (2003 (11.6566.8107))

    You are right on that one, it's so expensive that i won't bother about 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
  •