A few additional resources to look at would be MZ Tools 3.0 (free), which has a connection string building wizard, or www.connectionstrings.com. I have had very good luck with MZ tools, and the ADO string builder is just one of many highly useful features.

Another way to "cheat" and get a connection string is to create a linked table in Access then print/msgbox CurrentDb.TableDefs("MyTable").Connect and it will tell what string to use.