Okay this did not work, however it is not all bad what you gave me was a great test idea which has allowed me to locate the true problem of the connection string. So thanks a lot. So I decided I would hard code the path and see what happens. It worked when I put it back again to the variables for some reason visual studio gave a new error on the fill which gave away the source of the connection string problems. Somehow it is appending c: to whatever value is picked in the open file dialog box. HAHAHAHA now I see. Thanks for the vision. I will try fixing that because I cannot hard code this since the file is never in the same place.