I use SQLOLEDB a lot in my code, thinking I was bypassing some of the ODBC stack. Now it turns out we can use ODBC after all in our connection strings. Here is the post from Microsoft:

http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/29/microsoft-aligning-with-odbc.aspx

ADVERTISING
MS Access Consulting

It’s probably going to be a while but I would start replacing SQLOLEDB with ODBC from now on in your code.

Office SP1 damages Access?

Ben has a practice of avoiding SP1s of any kind and here’s why:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;2625046

Hold off on upgrading to SP1 until Microsoft has fixed this issue!