Microsoft Access’ Latest Bug Highlights The Importance Of Your Update Channel!

Maximize Stability in Microsoft Access: The Importance of Update Channels

Unless you’ve been living under a rock for the past 2 weeks, people have been dealing with the latest Microsoft Access bug.

Software Bug
Another msaccess.exe Process Not Closing Properly Bug
There isn’t much information at this point in time on the root cause and no official fix to the issue (there are workarounds however, see below), but it would seem that with the most recent update(s) Microsoft Access no longer closes properly and leaves instances of the msaccess.exe running in the background.

Continue reading →

Another msaccess.exe Process Not Closing Properly Bug

Software Bug

There isn’t much information at this point in time on the root cause and no official fix to the issue (there are workarounds however, see below), but it would seem that with the most recent update(s) Microsoft Access no longer closes properly and leaves instances of the msaccess.exe running in the background.

Continue reading →

Perform FTP Operations via VBA Using curl

So in my previous post, I demonstrated how we could use curl through VBA to download files or entire web pages:

How-to Download a Webpage or a File Using Curl
A while back, I played around with curl to send e-mails: and was surprised at how relatively easy it was to use. I have previous posted a few ways to download content from the web, such as: but decided to play around with curl on this since I knew that this was supposed to be another one of its strengths.

Today, I thought we could explore using curl to perform various FTP operations:

Basic curl FTP Commands

VBA curl FTP commands

Continue reading →

How-to Download a Webpage or a File Using Curl

A while back, I played around with curl to send e-mails:

VBA - Send Email Using Windows 10 Curl
In a recent discussion regarding automating e-mails in Access someone brought to my attention that Windows 10 has curl built into it, as of build 1803, which allows sending e-mails, amongst many other things. This got me curious if it could be a viable replace for say CDO Mail.  As such, I did some research, development and testing and ended up with the following function:

and was surprised at how relatively easy it was to use.

I have previous posted a few ways to download content from the web, such as:

Download a File From The Internet
Today, I thought I’d expand a little on a post I made in 2013: to adapt the routine to download a copy of the file.  This was actually brought upon by someone needing assistance in Experts-Exchange. The file in question makes no real difference, images, text files, … So this approach is very versatile and easy to use.   The General Idea Based on the original sample, we can read the file using XMLHTTP and then we can simply use ADODB stream to save what we read back to a file.

but decided to play around with curl on this since I knew that this was supposed to be another one of its strengths.

Continue reading →

Windows Extract All… Slower Than Molasses

A very short post to just mention that I have experienced, for some time now, major lag whenever I tried to unzip/decompress files using Microsoft Windows’ built-in Extract All… command. Even small zip files (a couple KBs in size) take way too long to extract.

I just wanted to advise anyone else experiencing this issue to get a 3rd party zip applications, such as 7-zip, and the difference in speed is night and day! We’re talking about speed differences of orders of magnitudes.

Now I have no clue as to what is wrong with the built-in command, but there are obvious issues and I’m not the only person having experienced this and I’ve found tons of threads on the matter (sadly no fixes though). It wasn’t always like this, so at some point, some update messed things up.

Continue reading →

Splitting a Large CSV into Multiple Smaller CSVs

I recently came across a forum question in which the user needed a way to break a huge CSV file into multiple smaller files while retaining the header row in each of the smaller files. In this instance the question was revolving around JavaScript, but it got me thinking as to how it could be approached in VB/VBA/VBScript.

Continue reading →

Domain Name Services Scam

I had a good laugh with a recent Scam I just received. The sad part is that although I recognize it for what it is, a scam, I know there are those out there that will fall for it.

So what is the Scam?

This ‘company’ of scammers send out officially looking like invoices to people making it look like you’ve done business with them and owe them moneys.  Their hook is that the invoice is for your soon to expire domain.

The issue is:

  1. You’ve never done business with them
  2. It isn’t for a domain you currently own

Continue reading →