by Jonathan Halder | Mar 21, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
Today, my customer for whom I had enabled transactions was having problems with the update routine. Ultimately, it stemmed from the fact that the Filter property is treated differently between the ADO recordset object and the DAO recordset object. I had originally...
by Jonathan Halder | Mar 20, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
So I had some legacy code that was testing an mdb connection to make sure it could get an exclusive lock on the file. If so, the code would then proceed doing an update procedure, but switched methods to use ADO. I am pretty certain that I wrote the code like 15 years...
by Jonathan Halder | Mar 18, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
Your development environment is important. You want to have fast performance as you develop and you want it to remain stable so it doesn’t crash. I have a decent desktop with 2TB of NVME storage (the fastest I could get when I built it), two monitors and 64GB of...
by Jonathan Halder | Mar 13, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding
If you want to get the number of records that were updated, inserted, or deleted by your query, you would read the RecordsAffected property on the object that executed your query after it had run. ‘Copied from a normal module ‘We set a reference to the...
by Jonathan Halder | Mar 10, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
I had a friend ask me for more info about using access files as libraries, so here is some info I gathered up: First off is a link to a file Steve Halder created when researching building our library for our Access JumpStart product. This has a lot of info and sample...
by Jonathan Halder | Mar 6, 2025 | Blogging, MS Access, MS Access Features, MS Access Tables
Today, I remembered a little factoid about Access database versions. You can’t link older front end Access files to newer back end Access files. My mission was to take a set of Access applications I had upgraded for one department (which is being used in...
