by Jonathan Halder | Jun 18, 2025 | Blogging, MS Access, MS Access Tables
As an overview, a big issue with multiple users is editing the same data and tables. The issue needs to be addressed differently depending on what backend you are accessing the data from. Today we’ll start the discussion with Access file backends. Access files...
by Jonathan Halder | Jun 16, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding
This is an entire planet to explore in and of itself. There are multiple layers of sharing when it comes to creating Access databases and applications with multiple users. Although fraught with land mines, users can use the same Access front end at the same time. This...
by Jonathan Halder | Jun 13, 2025 | Blogging, MS Access
Providing feedback and getting feedback is SOOO important. My customers give me an idea of what they want. It’s often in the form of some behavior they want from a form or data modeling on a report. It’s usually pretty minimal in content with an assumption...
by Jonathan Halder | Jun 12, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
Ok, so this really doesn’t qualify as test driven development because a key of that discipline is to automate your tests. That means you actually would have a set of functions that would automatically test various things as you create them and you leave those...
by Jonathan Halder | Jun 10, 2025 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
I find myself annoyed with my younger self as I slough through multiple views and queries to slightly change some things so that I can get a similar result set with slightly different customer requirements. Simply put, in this case, the main issue is that I have 2...