Here are two classes i wrote eons ago. They are available for free in my AdoDevKit and vbDevKit libraries but I hate always have to distribute another dll if i want to use them. so I am just goign to release them open source.
The Adokit has a nice BuildConnectionString function, and its nice to have the Execute as default method, but its error handling could use a couple tweaks (ie aiseEvent error() instead of a class throwing message boxes which annoy me to no end especially if in a dll):
CFileSystem2 has been in heavy use for years and years and should operate as expected (it is permissions unaware though)