Thanks Pirate...

A couple questions,

What connection should I if all I'm doing is connecting to my database locally? Standard or Secured?

Second, should the application be connectionless? In vb6 with access, I would establish a connection and keep it alive for the life of the application being open. But I read somewhere that the application should open a new connection , process the data then close the connection, is this true?