I know I’ve seen the solution to this one somewhere, but if you’re getting the following error on a 64-bit platform, the solution is to set your application to compile as “x86” and not “Any CPU”:

ERROR: 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.