Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Location
    Longmont, CO
    Posts
    258

    Unanswered: Access 2003 Security Annoyances

    Just tested my app on 2003 and discovered that several new security-related pop-ups are going to drive my users nuts.

    1) When they open the Access .mdb they get a warning alerting them that .mdb's are dangerous. They then have to click on this message in order to open the app.

    2) When they try to open Word merged documents that are created via the app, they get a warning saying that opening the .doc file will cause "SELECT * FROM..." and see my SQL statement for the merge. Once again the point of the email is that what they are doing is dangerous and they have to click to proceed.

    Anybody know how to turn these things off?

    Thanks!
    Fly Girl

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    you should lower security level of office applications. in Access go to menu:
    Tools->Macros->Security and set security level Low. that should stop warnings.
    ghozy.

  3. #3
    Join Date
    Feb 2004
    Posts
    533
    I have 2003 installed and have this problem with security warnings. Another option is to digitally sign your projects or use the Self Cert option as mentioned in the Access Help. I was looking at this a couple days ago but did not have the Self Cert options installed from the CD. For now just went with the easy answer and set Macro Security to Low, like ghozy said.
    Signing a VBA Project
    ~

    Bill

  4. #4
    Join Date
    Jun 2003
    Location
    Longmont, CO
    Posts
    258

    It worked!

    The annoying message from Access no longer appears by using the Tools>Macros>Security setting.

    We'll look into signing our stuff, that sounds like a better way to go in the end. However, the one customer that upgraded on me will appreciate the fast fix.

    Thanks guys!

Posting Permissions

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