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.

Read more ...

Trusted Locations and Trusted Documents

 When working twith Access 2007, 2010, 2013, and/or 2016 it is important to make sure to set the trused locations.

Read more ...