by Jonathan Halder | Dec 16, 2024 | Blogging, MS Access, MS Access VBA Coding, Versioning
Karl Donaubauer hosted the Access development team at his German Access Developers Conference and there are some cool things coming down the pipe for us. One of them is re-integrating source code control back into Access: https://youtu.be/dP-YljKct5M?t=943 At one time...
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...