by Jonathan Halder | Mar 6, 2025 | Blogging, MS Access, MS Access Features, MS Access Tables
Today, I remembered a little factoid about Access database versions. You can’t link older front end Access files to newer back end Access files. My mission was to take a set of Access applications I had upgraded for one department (which is being used in...
by Jonathan Halder | Feb 12, 2025 | Blogging, MS Access, MS Access Features
Access is an interesting animal. It’s a Windows desktop app included in the Microsoft Office family originally touted as a low-code no-code relational database management tool. It received decent attention for a while, getting relatively serious new features...
by Jonathan Halder | Jan 29, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
So the reason I was getting strange behavior in some tests I was running was because there was a third party class which responsibly used an error handling scheme used in it’s tests which required an error being raised with Err.Raise to pass up to the calling...
by Jonathan Halder | Jan 28, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
I am running into a situation in someone else’s code where an Err.Raise call is not getting handled by any of the upstream calling functions and ends up calling the main VBA system debugger displaying the VBA error dialog. I was trying to recreate the problem...
by Jonathan Halder | Jan 28, 2025 | MS Access, MS Access Features, MS Access VBA Coding, TDD, Versioning
As I was working on some code to store custom tags related to controls, I thought it would be nice to use a dictionary object. Dictionary objects work by storing a value of some kind along with a key to find it. The Scripting.Dictionary object uses the VBScript...
by Jonathan Halder | Jan 14, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
One strategy I have used to run automated processes with Access is to use Command Line switches. So to start up Access you use the Access program “MsAccess.exe”, usually with the full path to it, then use the database you are opening as an argument, and...
