by Jonathan Halder | Oct 8, 2024 | MS Access, MS Access VBA Coding, TDD
If you haven’t had the pleasure of Uncle Bob Martin books or videos, you’re missing out. I’d recommend a search on YouTube for Uncle Bob’s Clean Code. I watched a lot of his videos when I had an O’Reilly subscription and that led me to...
by Jonathan Halder | Oct 7, 2024 | Blogging, MS Access, MS Access Queries, MS Access Tables
This morning I was working on a query for a customer report that took me longer than I expected and produced more problems than I expected. I actually had 3 tables named customers, orders, and payments. Customers can have multiple orders, and have a one to many...
by Jonathan Halder | Oct 4, 2024 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
The Access 97 database I was trying to get working on my 365 Access was written to scramble data in existing tables in a destructive way so that users of a forum or other developers could look at code without seeing sensitive data. I copied some large tables I had...
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 | Oct 2, 2024 | Blogging, MS Access
I didn’t think this would be a showstopper, but guess what, it is! If you have a version of Access later than 2010, you cannot open an Access 95 or Access 97 database at all. You get a fun error message: And it won’t do anything with the database at all. I...
by Jonathan Halder | Sep 30, 2024 | Blogging, MS Access, MS Access VBA Coding
Our Access application framework that Steve and I developed and use to build our apps is called Access JumpStart. It does not include vbWatchdog by default for those who buy our framework, but it contains code to work with vbWatchdog if the developer of the app has...
