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:


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:


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