by Jonathan Halder | Aug 26, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today I had a request from a customer with a database used for What If scenarios to allow him to do either do updates from the main tables consistently or to boot all other users out of their front ends so that he can do an update when one is required. The system is...
by Jonathan Halder | Aug 11, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables
Most of my customers that I build Access apps for have not been Access users. In other words, they tend to know very little about tables or queries or reports, design view, VBA modules and macros. This tends to make my job easier in that I don’t have to be...
by Jonathan Halder | Aug 7, 2025 | Blogging, MS Access, MS Access Queries, MS Access Tables
I have a table that that stores info for a filename in each record, and another table that stores multiple rows for each file record representing the data. I wanted to update the file table with the maximum and minimum dates found in each record so I crafted a query...
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 | May 28, 2025 | Blogging, MS Access, MS Access Features, MS Access Tables, MS Access VBA Coding
I have a couple clients now who had emails they wanted to either send out on a scheduled basis, like every Thursday, and/or when certain events occurred, like importing a certain type of file with certain types of part numbers, or a po is updated and causes a project...
