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...
by Jonathan Halder | Apr 16, 2025 | Blogging, MS Access, MS Access Tables
As I was working in my dev copy of the client’s database today, I was using SQL Server quite a bit via SQL Server Management Studio SSMS. I noticed some slower performance on a couple of features I added multiple months ago that utilized new tables. So as I...
by Jonathan Halder | Apr 15, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today’s work was to fix logic errors in my application. The problem is that overlapping data in files that normally deletes the older data and replaces it with the newer data is replacing all the older data even though it is earlier than what appears in the...
