Data Access Macros – Unique To Microsoft Access Database 2010

Data Access Macros – Unique To Microsoft Access Database 2010

Access macros have always been around going right back to the earliest releases of the 1990′s and as new versions became more sophisticated and richer so macros had a more important role to play. VBA code of course was later introduced and is typically the number one choice for programmers but Access macros are making a come back with the new exclusive addition of Data Macros to Microsoft Access 2010.

Data Access Macros – Unique To Microsoft Access Database 2010

With the additional new enhancements of Data Access macros, the need to solely depend on Access VBA has diminished. The ‘Die-Hard’ developer may hold a debate on the power and benefits of using macros in the first lace but let me remind you that Microsoft Access wasn’t designed for the programmer – it was designed for the ‘Power-User’.

data access macrosUse Data Access macros to manage auto updates of records changes which is the equivalent to SQL Server Triggers and now if you play with this a little more, could you build your very first audit log system within Microsoft Access?

This entry was posted in Macros, MS Access, Utilities and tagged , , , , . Bookmark the permalink.

2 Responses to Data Access Macros – Unique To Microsoft Access Database 2010

  1. Giorgio Rovelli says:

    Hi Ben, I think you meant to say ‘audit tool’. Wasn’t it possible even before Access 2010 to keep track of record being edited? And when you say manage auto update of record changes do you mean you don’t need to requery the record on forms?

  2. Ben Beitler says:

    My next product will be to build a user friendly and generic ‘audit too’ to plug into your existing Access database. The question is do I use Data Access macros for version 2010?
    Anyone would like to comment on this?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Confirm you are human.