Well, since the chunk method has worked since at least Access 2.0, and is still viable in VB.Net, it should be viable in VBA 2003. So, it would seem you’re on the right track, although there are quite a number of variations of that code for different languages/versions. That means you may have to tweak your code a bit to make it work.
There are also certain limitations that aren’t always mentioned, such as the blob fields needing to be at the end of the SELECT list. And occasionally bugs crop up that prevent particular combinations of apps/OS’s from playing nicely together. (As I recall, NT 4.0 had some issues along these lines…probably a driver issue, although I don’t remember the details.)
So, if you got this code online, it almost certainly works for SOME combination. Give us the URL and maybe we can help tweak it into working order. It would also be extremely helpful to know what error you’re getting, and on what line of code it occurs.