Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    330
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Access 2003 runtime security (Access 2003)

    Hi All,

    In our small office, I am the only one who has full Access as I write and maintain our db, everyone else has ART. I have set the security for the db to low and have also created a digital signature that I have loaded onto all machines under trusted root certificates and all machines are running the latest patches. However, the ART machines show the "do you want to block unsafe expressions" dialog and the "you have unblocked expressions, do you still want to open this db" one.

    For most of my users, even trusting them to pick the correct answers is asking a bit much.

    Is there a way to get rid of these messages without blocking? As I'm not yet completely sure that all code will run if blocked.

    I thought that the database would inherite the security settings that I gave it when I distributed it, or is my lack of understanding showing here?
    "Heading for the deep end"

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

    Re: Access 2003 runtime security (Access 2003)

    Macro security is a user-level setting, not a database-level setting.

    MSKB article How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003 explains how to change the security level for expressions. I'd try setting the SandboxMode value in the registry to 0. This has to be done for each PC.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    330
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Access 2003 runtime security (Access 2003)

    Thanks for the info - also along these lines, I have turned off the confirmation messages for action queries in my copy of the database (which everyone else gets anyway) but they still show for everyone using ART. How can I set it to not show for them???
    "Heading for the deep end"

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

    Re: Access 2003 runtime security (Access 2003)

    Again, confirmation of action queries is a user-level setting, not a database-level setting. If you execute queries in code, you can use

    DoCmd.SetWarnings False
    ...
    DoCmd.SetWarnings True

    To change the option itself in code, you'd use

    Application.SetOption "Confirm Action Queries", False

    but I don't know if this works in Access Runtime.

Posting Permissions

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