Microsoft Most Valued Professional MVP - Access Expert

mvp.png

  Boyd Trimmell, aka HiTech Coach
  Microsoft MVP - Access Expert


What is a Microsoft  Most Valuable Professional (MVP)?
Microsoft  awards the Most Valuable Professional (MVP) in recognition of significant contributions made to technical communities by sharing high quality, real world expertise. Microsoft Most Valuable Professionals (MVPs) are a worldwide network of exceptional technical community leaders.

"If technology doesn't work for people, then it doesn't work."
- Kim Vicente

Access VBA has not really changed that much in many years for desktop applications. I have code that I wrote in Access 2.0 in 1994 that works in Access 2016.

If something worked in 2000 or 2002/2003 then it will probably work in the newer versions. Access 2007/2010/2013/2016 will open an Access 2000/2002/2003 database without having to convert it to a the newer accdb format.

There were a few new features introduced on Access 2007 that require the example to be in new 2007 (.accdb) database format. For example the attachment data type requires the accdb format with Access 2007 and later. Working with the things like the Ribbon, Rich Text, and Save as PDF also require the newer accdb format with Access 2007 and later.

Access 2010 introduced some new User Interface features for command buttons. The database will still work in 2007 but you will not see the new command button features. The button will look like the 2007 command buttons.

TIP: It is generally safe to assume that if an Access version is specified in an
artilce or example that is applies that version and later.

. You will find that a lot of articles examples are done with the oldest version possible that it will support it.  This allows a single article or example can be created that is compatible with many Access versions and reaching the larges possible audience. It is common for Authors to only update their articles and/or examples if it requires a change for the newer version of Access.

 

 That is why you see a lot more of examples that are in Access 2000 (mdb) or 2007 (accdb).   There are a lot fewer tings that require Acess 2010 and even less require Access 2013.  

 

When searching for examples keep in mind that all those Access 2000 or 2002/2003 examples will usually apply to Access 2007 and newer versions.