Tuesday, November 30, 2010

Enable Macros in Access 2007

  • We have a couple of access programs that we use for data conversions. These programs convert the csv files that are generated from our CRM to a fixed file format that is then uploaded to interface with other government institutions.
    With the introduction of OFfice 2007 there is this extra step that the users were required to do to enable macros manually every time they use these programs.
    I thought this manual should not be there for the users so I set out to look at all the options available to automate this step.
    HEre are the results.

  • Open the access file -- click on the office button at the top and click on Access Options
  • From the menu that appears choose the Trust Centre and click on the Trust Centre Settings.
  • From the menu that appears choose Macro settings and Enable (the fourth option) and click ok.
  • Next time when you open the porgram the annoying notification where there is a tendency to forget to enable will disappear.

No comments:

My Microsoft MVP Award

At the beginning of this month, I received an email from #microsoft telling me that I have received the Most Valuable Professional (MVP Awa...