I've worked with SQL / Access for over two years now and I still don't understand the connection strings....

Maybe you can find some answers here: http://connectionstrings.com/