by Jonathan Halder | Oct 21, 2024 | Blogging, MS Access, MS Access VBA Coding, Versioning
When working with a particular customer, it is very beneficial to have a plan on working on their database and being able to implement your new database changes effectively. Ideally, you might have a fully automated pipeline that would allow you to test and deploy a...
by Jonathan Halder | Oct 17, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD, Versioning
Back 6 months ago I was asked to add new fields to check for the validity of a line item on an order. This caused me to go through a rather extensive process to break dependencies on an Access form so that I could test it without having to launch the form and build an...
by Jonathan Halder | Oct 3, 2024 | Blogging, MS Access, Versioning
Thanks to a reader of Jon’s Access List, Xevi from Girona in Spain, I received a converted version of the Access 97 Data Scrambler database. The reader used Access 2010 to update the database to a format that could be read by the most recent versions of Access,...
by Jonathan Halder | Aug 1, 2024 | MS Access, Versioning
I use an SVN server to store versioning information for all my Access work that I do. A shout out to the OASISsvn Access Add In and TortoiseSVN for Windows which are two pieces of software I use daily in my Access versioning work. How it saved by butt today: I had a...
by Jonathan Halder | May 31, 2024 | MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding, Versioning
I have created a deployment script which is meant to prepare an Access JumpStart application for a specific live production environment. Access JumpStart is the framework Steve Halder and myself use in creating Access Applications for our customers. I have already...
by Jonathan Halder | May 30, 2024 | MS Access, MS Access VBA Coding, Versioning
Yesterday, I explained that the Access JumpStart system Steve Halder and I developed as a framework to use for our Access database clients has a nice little feature that allows you to set a whole set of global options and then define overrides for those options based...
