- Last Updated: 13 September 2020 13 September 2020
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 the newer accdb format.
There were a few new features introduced on Access 2007 that require the example to be in the new 2007 (.accdb) database format. For example, the attachment data type requires the accdb format with Access 2007 and later. Working with 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 largest 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 examples that are in Access 2000 (mdb) or 2007 (accdb). There are a lot fewer things that require Acess 2010 and even less require Access 2013.