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.. If something worked in 2000 or 2002/2003 then it will probably work in the newer versions. There were a few new features introduced on Access 2007 that require the example to be in 2007 (.accdb) format.
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.