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 | Oct 1, 2024 | Blogging
I have been following a system for several years now called EOS or Entrepreneurial Operating System: EOS – Entrepreneurial Operating System for Businesses, home of Traction tools & library (eosworldwide.com) It has helped me create a rythym to my work life,...
