We're nearing the end of Microsoft's unprecedented free upgrade offer for Windows 10.
The offer officially expires July 29, 2016, on the one-year anniversary of the operating system's initial release. But what happens then? [Updated]
[This article has been significantly revised and updated since its original publication. in January 2016]
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.