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 | Sep 25, 2024 | Blogging, MS Access, MS Access Tables, MS Access VBA Coding
I have finished coding the solution. I ended up using DAO after all. The solution grabs a collection containing info about the source and target database paths and table names. Then it loops through the collection, opens the target database, deletes the table if it...
by Jonathan Halder | Sep 24, 2024 | MS Access, MS Access Tables, MS Access VBA Coding
I received a task today to update a demo / WIP Access system which will be upgrading an existing Access system. Many parts of the system are the same, the upgrade is meant to address importing data from a new datasource. The customer is currently using both systems...
by Jonathan Halder | Sep 5, 2024 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding
So first things first. It is not recommended that you use spaces or special characters in your table names as it can cause problems referencing them or cases that are ambiguous and may cause unintended results in the code. But maybe you have used them in the...
by Jonathan Halder | Aug 27, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
There are of course a multitude of uses for a relational database system. Remember that although natively Access defaults to storing data relationally in tables using the file based ACE system (Access Connectivity Engine), it can really use any ODBC or OLE DB...
by Jonathan Halder | Aug 13, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
As I am continuing on my Test Driven Development journey, I am starting to learn how to write tests as I add new features to my code. A recent example would be a requirement to ask for a password if the user was trying to delete a line in an order. There are...
