Is your application 32 or 64-bit? If you are trying to compile/run as 64-bit or AnyCPU, try changing it to 32-bit (x86). Since you have 32-bit MS Office installed the ACE driver will most likely be the 32-bit version. We had a similar issue and upon doing
a little research it appeared that Microsoft doesn't support installing both the 32 and 64-bit ACE driver at the same time, so we have done something to first try to use the ACE driver and if that fails, fall back to the JET driver.
- Brady My posts are kept as simple as possible for easier understanding. In many cases you can probably optimize or spruce up what I present. Have fun coding!