What provider and driver offer the best performance when connection to SQL Server using ADO?
I'm connecting MS Access 2007 to SQL Server 2008.
Provider Options:
Driver Options:
You should test it in your specific environment to be sure. Whatever the performance differences are, they should be negligible.