Thank you Jmcilhinney

Your thread was of brilliant use and that solves alot of my questions with regards to connecting to a database. My final question is would it be good coding practice in .NET to write a module for the connection or just code everything as i need it.

Many Thanks
AJ