Results 1 to 3 of 3
  1. #1
    NISMOJim is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    255

    Digital signature

    I just converted a database from 2003 to 2007 and got my first look at the 2007 format. When I opened the db I get a security warning saying certain content has been disabled. I clicked the options button which said the potentially harmful content is VBA Macro. I was able to enable it for this session only, but I would like for it to run right whenever anyone opens it.
    I read that the macro must have a digital signature, and followed the path to select one, but there were no certificates to select. I'm sure I probably wouldn't want to enable all macros, but none of the other paths lead me to anything useful.
    How can I get by this, and will I need to do it for every db I create or convert from here on out?

    Thank you for your help.

  2. #2
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    636
    Hi,

    there is a much easier solution: if you open the trust center in the options window, click Trust center Settings. In this window click Trusted Locations, and add the location where your databases are to the trusted location. All databases that are put in this folder will open without security block or message.

    succes
    NG

  3. #3
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    700
    Quote Originally Posted by NISMOJim View Post
    I just converted a database from 2003 to 2007 and got my first look at the 2007 format. When I opened the db I get a security warning saying certain content has been disabled. I clicked the options button which said the potentially harmful content is VBA Macro. I was able to enable it for this session only, but I would like for it to run right whenever anyone opens it.
    I read that the macro must have a digital signature, and followed the path to select one, but there were no certificates to select. I'm sure I probably wouldn't want to enable all macros, but none of the other paths lead me to anything useful.
    How can I get by this, and will I need to do it for every db I create or convert from here on out?

    Thank you for your help.
    In Access 2007 and 2010 macros are always trusted. It is VBA code that is not trusted.

    If you were to use only macros then you would not have any security warnings. The macros in 2007 and 2010 are a lot more powerful so this becomes a little more practical.

    For any database that has VBA code you will need to follow NG's recommendation and create a trusted location for each folder where you will place a database. If you use sub folder all under the same parent folder for all your database then you can trust the parent folder and all the sub folder with one entry.
    Boyd Trimmell aka Hitechcoach
    Database Architect and Problem Solver
    Microsoft MVP - Access Expert
    25+ years specializing in Accounting, Inventory, and CRM systems
    "If technology doesn't work for people, then it doesn't work."

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 16
    Last Post: 12-06-2015, 04:48 PM
  2. Add Signature Box in a form
    By kowsigan in forum Forms
    Replies: 1
    Last Post: 12-20-2010, 03:58 PM
  3. scanned signature(s) on a report
    By thedoc44 in forum Access
    Replies: 7
    Last Post: 09-15-2010, 10:54 PM
  4. Replies: 0
    Last Post: 04-24-2009, 12:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums