by Jonathan Halder | Aug 4, 2025 | Blogging, MS Access, Versioning
Versioning systems are great for me as a business entity. It gives me control over updates and changing objects and code, allowing me to go to previous versions easily and prevents the dreaded “Where did that feature go?” problem. But what if the customer...
by Jonathan Halder | Jul 18, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
In my continuing AI adventures, I have decided to attempt to use a tool called Augment Code which can analyze and index my code base via Visual Studio Code. Visual Studio Code: An open source Code Editing IDE for multiple languages with a large number of extensions....
by Jonathan Halder | Jul 15, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
Today, I was thinking more about using AI and Access. Particularly VBA, but I’d also like to be able to see if AI can understand my exported Access object files (I’m using OASIS SVN to export the Access objects currently, but there are other apps that can...
by Jonathan Halder | Jul 1, 2025 | Blogging, MS Access, MS Access Features, TDD, Versioning
Yesterday, I had found a method for CoPilot to see an entire database. In order to do this, all the objects of the database need to be exported to text files. This is an undocumented and unsupported feature of Access, but it has been there for a long time and is what...
by Jonathan Halder | Jun 30, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
Just now I was thinking it sure would be nice if CoPilot could analyze my Access database and give me tips on things. So I tried an experiment. I asked CoPilot if it could create databases or if I could upload my database for it to analyze. It thought it would be able...
by Jonathan Halder | May 23, 2025 | MS Access, MS Access VBA Coding, Versioning
I have been playing a little bit with the SDOpenAI Access Add In. In particular testing what context is being sent to the API in different situations. When your cursor has nothing selected, the general chat context will send the current line your cursor is on. When...
