Thanks John I know it had to be simple :)
Ron
>Hi Ronald...
>
>The process do this is very simple.. Try these steps...
>
>1. Create a dummy DBC
>2. create a connection
>3. In the connection designer, choose to create a connection string
>4. Press the button with the elipses... next to the textbox where the connection
> string will go.
>5. Complete the process of creating the data source
>
>When you have completed the process, the connection string will display. You can copy and paste this string into your code...