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.
Tuesday, November 30, 2010
Enable Macros in Access 2007
Below is a process that I follow every year to create a partition in existing multi-dimensional SSAS cubes that I maintain. Log in to t...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
Did you ever have a situation where you felt like converting a Sql Server Analysis Services in Multidimensional Mode to Tabular Mode ? ...
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...