I have been using the Access runtime since 1997 when I purchased the Access Developer edition. The Developer edition included a license to distribute the Access runtime. Starting with Access 2007 Microsoft has made the developer extensions and a license to distribute the runtime free.
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.
What? How can that be? I am able to create tables in Access. This is true because Access really is a Front End to a database engine.
Access interfaces with a database engine that manages the database. Access is a GUI front end for the JET and/or ACE database engines depending on the version of Access. The JET database engine is what manages the .mdb format. In Access 2007 there was a new database engine introduced called ACE. ACE is what manages the new .accdb format.
I have been working on a Windwos PC everyday for mnany years now. Windows has some great features built-in. There are some missing features that I need on every PC. I have compiled a list of some tools and utilites I like to insall on evey PC.
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.